View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Matching values in two columns

Correction - filter for FALSE values in column A.


"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