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

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

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

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

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