|
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
|
pivot table. summarize data by percent of total. (you can send me if you want.)
|
if he wants it to be living (like, if another 2 is added, immediately the percentage changes) you could do a countif to count values and divide by a simple count.
right?
|
Responses:
|