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.
XXplore Well, I can assure you that it does not!
I3=COUNTA(TEXTSPLIT(TEXTJOIN(CHAR(10),TRUE,Table1[@Bus],Table1[@Sci],Table1[@Med],Table1[@Psy],Table1[@Eng]),CHAR(10)))