ST Alpha - "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" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 156

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

Posted by mr monkey (aka chris) Sep 23 '16, 11:52

as a % of the total

Responses:

if I understand what you want correctly - decline Sep 23, 12:00 3
- 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
pivot table. summarize data by percent of total. (you can send me if you want.) - university of amanda jones Sep 23, 11:58 2
- yes, COUNTIF -- nm - mr monkey Sep 23, 11:59
- I am on google IM if you need. whatmary or macaroon. -- nm - university of amanda jones Sep 23, 11:58
Pivot table! -- nm - znufrii, dad. Sep 23, 11:57 7
- no -- nm - mr monkey Sep 23, 11:57 6
  - Actually, yes. - znufrii, dad. Sep 23, 11:59 5
    - if he wants it to be living a pivot won't work. -- nm - university of amanda jones Sep 23, 12:01 4
      - It should as long as you set the pivot area to be $A:$B it will pick up all rows. - spamlet Sep 23, 12:28
      - Bah. -- nm - znufrii, dad. Sep 23, 12:09 2
        
        Sounds like you are not getting enough sleep. -- nm - Spawn Sep 23, 12:19 1
        
        No complaints there, actually. -- (edited) - znufrii, dad. Sep 23, 12:35
(but i don't want an array. i just want it to count each unique value every time it occurs) -- nm - mr monkey Sep 23, 11:54

Post a message top

Replies are disabled on threads older than 7 days.