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. |
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. |
All times are GMT +1. The time now is 03:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com