Matching

  • Thread starter Thread starter intheway
  • Start date Start date
I

intheway

I have two columns that contain outstanding and cleared checks. I need
Excel to match the two columns, and let me know which checks are still
outstanding. The data are in columms A & B????
 
Hi

In C2, use
=COUNTIF(A:A,B2)
and fill down.

This will give you a count of how many times (if at all) B2 is found in
column A

Andy.
 
Back
Top