Forum Home
Press F1
 
Thread ID: 5120 2000-07-29 10:47:00 XL ? how to count # of specific names in column Arows Guest (0) Press F1
Post ID Timestamp Content User
5619 2000-07-29 10:47:00 XL ? how to count # of names in columns.

I have a spreadsheet in which column A has 1500 enteries, like John Smith, next cell Mary Cousins etc. How do I count the number of cells with, say John in them in the range.

XL does seam to be able to count specific test within a cell, is there a way to do this?

Cheers?.John jhw@xtra.co.nz
Guest (0)
1