| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I sort an entire spreadsheet from a list
I would like to sort a spreadsheet using column B by a list found in column A
that contains mostly matches to column B. I would like for columns B and up to be sorted using the list in A. If a cell value in A does not match any in column B, I want that value moved to the end of column A. I use the custom list option to achieve this right now, but it is very cumbersome and limited. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I add a dropdown list in a spreadsheet? | New Users to Excel | |||
| How do I sort a birthdate list by month then day regardless of ye. | Excel Discussion (Misc queries) | |||
| How to sort a list correctly? | New Users to Excel | |||
Threaded Mode
