Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching values in two columns
Hi,
I have two columns of numbers of about 5,000 rows. EG: 1 8 2 3 6 2 3 5 In this example I just want the numbers 2 and 3 to be left showing in the left column. I would like to show only the numbers in the first column that don't have a corresponding matching number anywhere in the second column. (Or highlighted in colour.) Is there a way to do this? Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Matching Data Two Columns | Excel Worksheet Functions | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
Formula to count values in two columns | Excel Discussion (Misc queries) | |||
Req help matching values across columns in Excel | Excel Worksheet Functions | |||
MATCHING COLUMNS | Excel Discussion (Misc queries) |