ST Alpha - "Since I'm here, you all are here, I'm going to make you do some Excel work..." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 162

Since I'm here, you all are here, I'm going to make you do some Excel work...

Posted by Mel Profit (aka Mel Profit) Nov 5 '24, 07:26

I have a sheet. I have multiple duplicative rows (save for a few columns). How do I COUNT the like rows so it displays in its own column or at the bottom? I've tried COUNT and SUBTOTAL.

exam:

aaa bbb ccc
aaa bbb ccc
aaa bbb ccc
ddd eee fff
ddd eee fff
ddd eee fff
ddd eee fff
ggg hhh iii
ggg hhh iii
jjj kkk lll

Responses:

countif. You may need several -- nm - Fuzzy Nov 5, 07:46 1
- If the sequences are in different columns you use countif + countif + countif. - amanda Nov 5, 07:49
I am a rookie. Assuming I know the value I'm looking for, I add a column with IF= and tally a 1. Then sum the column. - VMan Nov 5, 07:38
pivot table with the count of each value? -- nm - oblique Nov 5, 07:28 6
- 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

Since I'm here, you all are here, I'm going to make you do some Excel work...

Replies are disabled on threads older than 7 days.