| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching values in two columns
You are quite welcome.
"Rob" wrote: Thanks JMB, worked great!! Rob "JMB" wrote in message ... One way, where your first column of number is in B1:B5000 and the second is in C1:C5000, enter in A1 =ISNUMBER(MATCH(B1, C$1:C$5000,0)) and copy/fill down column A. Then use the autofilter on column A to filter for TRUE values. "Rob" wrote: 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) | |||
Threaded Mode
