ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/179405-excel-2002-a.html)

ericdadof3

excel 2002
 
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[_2_]

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

--
Jim
"ericdadof3" wrote in message
...
| 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




All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com