Function To Lookup Unique Records In 2 Sets Of Data

[James Al]

Can someone please help me with the following. I am trying to lookup values
in 2 sets of data to provide 1 list with all unique records. For example:
Range a: 1, 2, 3
Range b: 1, 2, 4, 5
These value ranges are populating columns a and b and I want to be able to
populate column c with values 1, 2, 3, 4, 5 using a cross lookup function of
some sort. Because of the nature of the spreadsheet that I am working on I
want to keep user intervention to a minimum and so using the advanced filter
is not an option.

 

[Marcelo]

did you try a pivot table?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"James Al" escreveu:

 

[Alan Beban]

Can someone please help me with the following. I am trying to lookup values
in 2 sets of data to provide 1 list with all unique records. For example:
Range a: 1, 2, 3
Range b: 1, 2, 4, 5
These value ranges are populating columns a and b and I want to be able to
populate column c with values 1, 2, 3, 4, 5 using a cross lookup function of
some sort. Because of the nature of the spreadsheet that I am working on I
want to keep user intervention to a minimum and so using the advanced filter
is not an option.

If the functions in the freely downloadable file at
http://home.pacbell.net are available to your workbook, then if "rng" is
the name of your data range

=INDEX(ArrayUniques(rng),ROW(1:1),1) entered in C1 and filled down as
far as required.

Alan Beban