comparing columns

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Is there a way I can compare 2 separate columns (ranges,
NOT specific numbers) and have excel pull out and list any
exact matches?

If I have 1 column that has over 20,000 numbers (rows) and
my 2nd column have 700 numbers (rows)...I need to see if
any of the 700 are also listed among the 20,000.

If this is possible, can I do this across worksheets?
 
With your 20,000 numbers in col. A and 700 in col. B, put
this in C1 and fill down to then end of your list in col.
B:

=COUNTIF(A:A,B1)>0

TRUE means found in col. A.

As for across multiple worksheets, that gets trickier. You
need to be more specific on what you're looking to do in
that scenario.

HTH
Jason
Atlanta, GA
 
Back
Top