Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello--
I have several sheets, Sheet1, Sheet2, Sheet3, etc. Each has a column of ID numbers in column A, some of which are duplicates across the sheets. I would like to create a master list of all ID numbers on another sheet called Master. Is there a relatively easy way to do this using formulas on the Master sheet? For example: Sheet1 A 99-1 100-3 500-4 Sheet 2 A 88-4 99-1 500-4 34-9 Sheet3 A 500-4 34-9 51-10 62-9 I'd like the Master sheet to have all of the ID numbers in one column (the order is not important): A 99-1 100-3 500-4 88-4 34-9 51-10 62-9 Thanks! Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Spreadsheet combining data from 3 columns to 1 column | Excel Discussion (Misc queries) | |||
Combining 1 column into many columns | Excel Discussion (Misc queries) | |||
combining multiple columns into one column - enhancements | Excel Worksheet Functions | |||
Combining mutiple columns into one column | Excel Worksheet Functions | |||
Appending Values in the Legend | Charts and Charting in Excel |