View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason[_11_] Jason[_11_] is offline
external usenet poster
 
Posts: 17
Default Combining data from two columns into one - appending new values tothe end of one column

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