Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Look up values in one column and compare with another
I have a column in one worksheet and a column in another worksheet
(both in the same workbook). The list is huge and I need to check one column against another for duplicates and remove the duplicate from one column Worksheet 1 A101111 A101222 B023455 B334455 Worksheet 2 A102222 A101222 B023333 B224455 How do I create a formula to look up the duplicate and highlight it so that I can delete it from worksheet 2? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Look up values in one column and compare with another
http://www.cpearson.com/excel/Duplicates.aspx
-- Regards, Peo Sjoblom " wrote in message oups.com... I have a column in one worksheet and a column in another worksheet (both in the same workbook). The list is huge and I need to check one column against another for duplicates and remove the duplicate from one column Worksheet 1 A101111 A101222 B023455 B334455 Worksheet 2 A102222 A101222 B023333 B224455 How do I create a formula to look up the duplicate and highlight it so that I can delete it from worksheet 2? Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Look up values in one column and compare with another
Look in the vba help index for FINDNEXT
-- Don Guillett Microsoft MVP Excel SalesAid Software " wrote in message oups.com... I have a column in one worksheet and a column in another worksheet (both in the same workbook). The list is huge and I need to check one column against another for duplicates and remove the duplicate from one column Worksheet 1 A101111 A101222 B023455 B334455 Worksheet 2 A102222 A101222 B023333 B224455 How do I create a formula to look up the duplicate and highlight it so that I can delete it from worksheet 2? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO COMPARE COLUMN VALUES IN EXCEL? | Excel Worksheet Functions | |||
Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |