Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generate list from column
I have a worksheet with a list of random phone numbers in column A. The
numbers are repeated a number of times. For example, there may be 100 entries made up of 15 numbers. I would like to be able gather those 15 numbers and list them on another sheet in column A. Example: Sheet 1 A A C B C D B Sheet 2 A C B D Any ideas. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I generate a list of the worksheets by name | Excel Discussion (Misc queries) | |||
how do generate a drop down list with no blanks | Excel Discussion (Misc queries) | |||
generate a selective list | Excel Discussion (Misc queries) | |||
Generate a value from user selection in list box. | Excel Discussion (Misc queries) | |||
generate a menu list | Excel Discussion (Misc queries) |