Number of times a specific value is displayed in data set

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to analyse some data in an excel spread sheet. I need to be able to display the number of times a certain value is encountered, eg



1 2.

2 2.

3 2.

4 2.

5 2.

6 2.

7 2.

8 2.

9 2.

10 2.

11 2.



I need to display that the value 2.3 appears four times and 2.5 appears twice

I have tried the frequency function but it does not work as I though
 
David,

This is what you want

=COUNTIF(A:A,2.3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

David Mc said:
I have to analyse some data in an excel spread sheet. I need to be able to
Click to expand...
display the number of times a certain value is encountered, eg.
 
David,

An easy way to do it is to sort on the value and then use subtotals,
function: Count.

HTH,
Nikos

David Mc said:
I have to analyse some data in an excel spread sheet. I need to be able to
Click to expand...
display the number of times a certain value is encountered, eg.
 
Back
Top