Count Number of Times Something appears

[Guest]

On Sheet 1, I want to put a formula in ColA that tells the number of times
ColB occurs in Sheet 2, ColA. THANKS!

Sheet 1 Sheet 2
ColA ColB ColA
A401 A401
A402 A401
A403 A402
A404 A402
A405 A403
A404
A404
A405

 

[John Michl]

Use the CountIF function.

- John

 

[Bob Phillips]

=COUNTIF(Sheet2!A:A,B1)

etc.

--

HTH

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

 

[Guest]

=COUNTIF(Sheet2!A:A,B1)

Thanks Bob, that's great...

 

[Guest]

Hey Mark,
If you want to give Bob the credit, you should mark this question "answered."

 

[Bob Phillips]

Where I am Anne, the public newsgroups, there is no such concept ).

--

HTH

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