0
votes
0answers
29 views

Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like: I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not). I have checked for ...
0
votes
1answer
139 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
2answers
175 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
0answers
704 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
1answer
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
2answers
665 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
2answers
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
2answers
432 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
3answers
924 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
2answers
230 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
1answer
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
3answers
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
3answers
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 ...