Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate lists!!!
Hi
I currently have a list (List A) off addresses that have certain information such as grid points, type etc. I also have a list (List B) that is currently being created and i would like to be able to delete anything off list A (that has the extra detail) against list B that is being generated and added to daily. So i am left with List A matching list B and still retains all the extra data in it. I am using Column E for house number and Column H for the road name in both lists. I tried to use an advanced filter but that just deletes the duplicates leaving me with the addresses i don't need. I wasn't sure if i could put something in the last column AH to high light the duplicates so i could filter the column and be left with my complete list. Ideally i would like to be able to check it every other day as list b grows. Hope this makes sense! Many thanks for looking |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate and unique items in 2 lists | Excel Discussion (Misc queries) | |||
Duplicate & Zero Values in Lists (Excel 2003) | Excel Worksheet Functions | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |