View Full Version : XL ? how to count # of specific names in column Arows

29-07-2000, 10:47 PM
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