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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access database invalid syntax error message 0
Macro for Bank Reconciliation 2
how do i filter check boxes? 3
match list 4
<ASK> How to add columm more than the default columm IV 3
Formula to match two conditions 2
function to return two different results 2
Checks, Matching and deleting numbers 2

Back
Top