Ooops, mine should have been A3 in the formula :)
--
** John C **

"John C" wrote:

On sheet 2, in cell B3:
=COUNTIF(Sheet1!$C$2:$C$1000,A2)
Note: the range should include all the data entries from Sheet1
Then copy this formula all the way down to B18.

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"tech1NJ" wrote:

I am working with a book and 2 sheets. Sheet 1 has data on 3 columns and 100s
of rows. Sheet 2 has specific names in ColumnA3 to A18 that may show up on
Sheet 1 column C. What I like to do is count the number of times the name
appears in Sheet 1 Column C. The number should be logged into Sheet 2 B3 to
B18. Is there a way to do this.

PLEASE HELP!!!!!!!!!!!!!!!--
tech1NJ