How do I compare two lists of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Back
Top