| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetized reference to a list
I have a list of text ('Sheet1'!A1:A100). The list could contain empty
fields, and the contents of this list could change. 1) I want to create a list in Sheet2 that is the above list alphabetized. (Changes in the original list must of course result in changes in this list) 2) Alternatively, I want to create a list in Sheet2 that removes all blanks (empty fields) or a least pushes them to the end of the list. How do I do these? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are my Excel columns numbered and not alphabetized (A..ZZ)? | Excel Discussion (Misc queries) | |||
| Why are my Excel columns numbered and not alphabetized (A..ZZ)? | Excel Discussion (Misc queries) | |||
| Items in drop-down list alphabetized | Excel Worksheet Functions | |||
| Searching an Alphabetized list for data, then RESORT | Excel Worksheet Functions | |||
| How do you list the numbers in a 3d reference in excel? | Excel Worksheet Functions | |||
Threaded Mode
