Apr 29 2021 08:35 PM
HI,
I have a number of people who've responded to a survey, saying the region in which they live, and then the key townships they visit.
I want to display that data in a way that shows what towns people visit.
I have responses by column, and I want to run a countif ( i think) on the table, showing how often the townships occur. I can't seem to figure out a way without doing it manually?
Apr 29 2021 10:03 PM
Solution@bhopenz Perhaps a simple COUNTIF is enough. Have converted the table with the answers to a structured table, by the way. Then you can reference the entire table by its name and count the occurrences for each of the listed townships.
See attached.
May 03 2021 01:54 PM
Apr 29 2021 10:03 PM
Solution@bhopenz Perhaps a simple COUNTIF is enough. Have converted the table with the answers to a structured table, by the way. Then you can reference the entire table by its name and count the occurrences for each of the listed townships.
See attached.