Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Selecting matching items in a column
I need to sort matching numbers from a column. For example,
12345 12.00 23456 10.00 34567 8.00 34567 -8.00 45678 6.50 56789 14.50 56789 -8.25 67890 -1.00 67890 -5.00 78901 -2.00 Result 34567 8.00 34567 -8.00 56789 14.50 56789 -8.25 67890 -1.00 67890 -5.00 |
#2
|
|||
|
|||
One way
highlight the range. DataSort HTH "Panajohn" wrote: I need to sort matching numbers from a column. For example, 12345 12.00 23456 10.00 34567 8.00 34567 -8.00 45678 6.50 56789 14.50 56789 -8.25 67890 -1.00 67890 -5.00 78901 -2.00 Result 34567 8.00 34567 -8.00 56789 14.50 56789 -8.25 67890 -1.00 67890 -5.00 |
#3
|
|||
|
|||
Try this. 1. You should designate a header name at the top of the column such as Name, SSN#, Date, whatever best suites the title of the column or columns you wish to sort. 2. Select the entire range you wish to sort, such as A1 to D20, including your header names. 3. From the tool bar click on, Data / Sort. Notice in the Sort window you have the option to select ascending, descending, header or no header, it’s up to you. 4. Select heading by which to sort under. It will default to the first row with whatever entry is at the top of the column. If you want to sort with another title such as SSN#, than select as an additional sort criteria. 5. Hit OK and your list has been sorted. Matt -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310 View this thread: http://www.excelforum.com/showthread...hreadid=395902 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I place items in alphabetical order in a column and keep da | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Selecting a column with an integer | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |