Forum Discussion
Solved
Excel pivot table help @members
Hi i would wanna ask how do you count the names with the table below? Because i have to show a column where which topic is more people prefer. Like how do i turn counting names to number and sum it?...
pan-g I replicated a small part of your table and used Power Query to extract and count the names per Topic.
See if this does what you had in mind. File attached.
J4=COUNTA(E4:I4)
Missed that you have several lines in one range. I think this works:
=COUNTA(TEXTSPLIT(TEXTJOIN(E2,F2,G2,H2,I2),CHAR(10)))
---
Updates:
=COUNTA(TEXTSPLIT(TEXTJOIN(CHAR(10),TRUE,E2,F2,G2,H2,I2),CHAR(10)))XXplore Well, I can assure you that it does not!
