# Tagged Questions

**0**

votes

**1**answer

115 views

### Grouping and sorting rows in Excel based on single column

I have a list of families I need to sort by last name in column A. You can see that each child in the family has its own row. The problem is that when you apply sort by column A descending, it does ...

**2**

votes

**2**answers

150 views

### Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X
Example:
A B C
1 1 X=7
2 3
3 5
4 8 ANS=5
Do you have any smart ideas for this problem?

**2**

votes

**0**answers

651 views

### Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...

**0**

votes

**1**answer

1k views

### How can I sort a list of numbers, by its last 3 digits in Excel

I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...).
Each one of the nubers if have 8-9 digits and I would like to sort this column by its ...

**0**

votes

**2**answers

642 views

### Why do I get an #REF! error after sorting?

In my workbook I use this formula:
=INDEX('G:\Manufacturing\WH\EXPORTS\Scanning_Reports [ScanningReport.xls]Sheet1'!$D$1:$D$65536;AB3)
It works fine but when i try to sort the data i got a #ref! ...

**1**

vote

**2**answers

86 views

### sort numbers in excel10

this is a sample of my movie list as you can see 61 is at the top and 8mm at the bottom
please explain how i can have 1 at the top and 3000 at bottom
61
.45 2006 dvd
10 1979 dvd
10 items or less 2006 ...

**2**

votes

**2**answers

417 views

### Excel mass add Data to existing sheet

I have an Excel Sheet with keeps track of Persons, who have gone to certain Activities. Now i want to add an Activity with hundreds of Persons, of which some have gone to others already.
Then I want ...

**0**

votes

**3**answers

896 views

### Excel 2010: Do sortable tables support sorting within multiple columns?

In Excel 2010 (and perhaps recent versions), you can select a range of data and insert a table over it that adds user-friendly sorting capabilities to the data. However, it appears that it doesn't ...

**5**

votes

**2**answers

227 views

### How do I expand columns of items in Excel so that each item is on its own line?

I have this:
-----A-----|-----B-----|-----C-----
1|cherry |apple |banana
2|kiwi |banana |cantaloupe
3|peach |grape |peach
4| |peach |watermelon
5| ...

**0**

votes

**1**answer

154 views

### Use Excel to select the most recent row from a CSV?

I have a CSV that starts with a date/time field and I need to import, and select the most recent row and refer to it in my formulas.
I'm experimenting with Pivot Tables, and just now Rank and ...

**1**

vote

**3**answers

2k views

### Advanced sorting in excel

I have a data in excel in the format:
Description Name Percent
Always A 52
Sometimes A 23
Usually A 25
...

**4**

votes

**3**answers

2k views

### How to sort list-style numbers in Excel?

I have a column of "numbers" in Excel that I would like to sort as follows:
1.1
1.2
1.2.1
1.2.6
1.2.9
1.2.10
1.2.11
1.3
However, regardless if the cell's type is number or text, Excel sorts them as ...