ST Alpha - "if I understand what you want correctly" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 156

In response to "excel q: how to calclulate frequency of values in a range, e.g., i've got a row with a bunch of numbers and my boss wants to know each unique value" by mr monkey

if I understand what you want correctly

Posted by decline (aka Decline) Sep 23 '16, 12:00

assuming your cells are rows A1 to A25

In cell B1 put:

=COUNTIF(A$1:A$25,A1)/COUNT(A$1:A$25)

copy that down to cell B25

Each cell in column B will then show you the percent each corresponding column A is a part of the whole

Responses:

grazie! -- nm - mr monkey Sep 23, 12:01 2
- if you plan to add cells at the end remember you'll need to adjust the ending range - decline Sep 23, 12:04 1
  - way ahead of you, mi amigo! -- nm - mr monkey Sep 23, 12:16

Post a message top

if I understand what you want correctly

Replies are disabled on threads older than 7 days.