ExcelBanter - How do I compare two lists of numbers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I compare two lists of numbers? (https://www.excelbanter.com/excel-worksheet-functions/23119-how-do-i-compare-two-lists-numbers.html)

demebe123

How do I compare two lists of numbers?

I have a long list of numbers in two columns. I want to find out what
numbers are in column A that are not in column B. Is it possible to use
conditional formatting to do that?

Bob Phillips

Yes, Select column A, and use a formula of

=COUNTIF($B:$B,A1)=0

--

HTH

RP
(remove nothere from the email address if mailing direct)

"demebe123" wrote in message
...
I have a long list of numbers in two columns. I want to find out what
numbers are in column A that are not in column B. Is it possible to use
conditional formatting to do that?

All times are GMT +1. The time now is 04:53 AM.