ST Alpha - "pivot table with the count of each value? -- nm" (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: 162

In response to "Since I'm here, you all are here, I'm going to make you do some Excel work..." by Mel Profit

pivot table with the count of each value? -- nm

Posted by oblique (aka kkuphal) Nov 5 '24, 07:28

(No message)

Responses:

When I use that it cascades - Mel Profit Nov 5, 07:32 5
- Can you countif and use "*aaa*" as the criteria ? -- nm - amanda Nov 5, 07:46 1
  - Looking into that. Thanks. -- nm - Mel Profit Nov 5, 07:47
- are aaa bbbb ccc separate columns? -- nm - oblique Nov 5, 07:42 2
  - They are. -- nm - Mel Profit Nov 5, 07:47 1
    - some googling suggests that VSTACK or HSTACK with UNIQUE might be the route -- (edited) - oblique Nov 5, 07:51

Post a message top

Replies are disabled on threads older than 7 days.