- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- stat analysis problem

Subject: | stat analysis problem |

Posted by: | John Doe (alwa…@in.style) |

Date: | Wed, 15 Oct 2003 |

et al,

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

'5'.

Is there a way to do this in excel?

TIA.

-JD

- Re: stat analysis problem posted by tim otero on Thu, 16 Oct 2003