excel 2002

[ericdadof3]

I've been trying to figure out how to combine 2 parts lists in EXcel and have
all the duplicate items automatically deleted or hidden.
(Think of comparing the price list for all the parts of a '66 mustang with
all the parts on a '67 mustang if that helps any)
Any guidance would be appreciated

 

[Jim Rech]

The Data, Filter, Advanced Filter feature can be used to create a new list
from an existing list with exact duplicates removed.

--
Jim
| I've been trying to figure out how to combine 2 parts lists in EXcel and
have
| all the duplicate items automatically deleted or hidden.
| (Think of comparing the price list for all the parts of a '66 mustang with
| all the parts on a '67 mustang if that helps any)
| Any guidance would be appreciated