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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generate list from column
The easiest way to do this is to use the advanced filter.
Navigate to the location where you want this data to appear. Goto the menu DataFilterAdvanced Filter Select Copy to another location List range - is the location of the data. So, enter the range of cells where your data is located (include the column header) Copy to - this is where you want the extracted data to appear. Since you're already on that sheet just enter A1. Select Unique records only OK Biff "dhays" wrote in message ... 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. |
Reply |
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) |