Tagged Questions
0
votes
1answer
67 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
119 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
62 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
144 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
465 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
181 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
122 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
909 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
1k 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 ...
