|Subject:||stat analysis problem|
|Posted by:||John Doe (alwa…@in.style)|
|Date:||Wed, 15 Oct 2003|
Here is the problem I'm having.
I have a column of data (say column 'b') that has numbers in it. both in
the format of '5' '98' '444' etc. What I'm trying to do is come up w/ a
formula that will tell me the number of occurrences in that column of any
number. i.e.. say 5. when I would do count on the above I get an answer
of 3 ( =count(cell1:cell2,5). Or even in the formula when I put the 5 in as
Is there a way to do this in excel?