PERCENTRANK function

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

Guest

Hi, being a bit thick here - I know that the formula =PERCENTRANK({1,2,3},3) will give me the percentage of 3, i.e. 100%, 2 would be 50% etc - am I on the right track to apply this to a column of values of between 1 - 3, so it will tell me what percentage of values in the column were '3', what percentage were '2' etc, and if so how will I construct the formula? Or, if not, how could I go about this? Am working with survey statistics, and I'm stumped!

Thanks
 
Abby

If I have understood you properly, assuming data
in A2:A100, this formula will do the job:

=COUNTIF(A2:A100,N)/ROWS(A2:A100)

Where N is 1, 2 or 3

Format the result cell as percent.


--
Best Regards
Leo Heuser

Followup to newsgroup only please.

AbbyLT said:
Hi, being a bit thick here - I know that the formula
Click to expand...
=PERCENTRANK({1,2,3},3) will give me the percentage of 3, i.e. 100%, 2 would
be 50% etc - am I on the right track to apply this to a column of values of
between 1 - 3, so it will tell me what percentage of values in the column
were '3', what percentage were '2' etc, and if so how will I construct the
formula? Or, if not, how could I go about this? Am working with survey
statistics, and I'm stumped!
 
Back
Top