I am trying to combine multiple lists of Items in one master list and would
like to eliminate doubling the same #s which can exist in several Lists. need
help with the Formula???

Hi,

In 2007 - combine all the list by copy/paste below each other. Then choose
the command Data, Remove Duplicates....

In 2003 - combine all the list by copy/paste below each other. Select just
the column with the repeat numbers and then choose Data, Filter, Advanced
filter, Copy to another location, make sure the list range is just your
number column with a single title at the top, no Criteria range, the first
cell of a blank column for the Copy to range, lets say D1. Check Unique
records only and then OK.
Now build VLOOKUP functions to retrieve any other columns of data you want.

You could also use a VBA macro.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Packaging" wrote:

I am trying to combine multiple lists of Items in one master list and would
like to eliminate doubling the same #s which can exist in several Lists. need
help with the Formula???