I am trying to create a tally chart.
I have a spreadsheet with a drop down list containing roughly 30 different selections.
When the same selection has been selected multiple times, I ideally want them tallied in
a separate table on the same sheet. The top 5. I want the name of the selection to be copied
over as well as tallying the amount of occurrences. Is this possible?
The spreadsheet looks like this...
<tbody>
</tbody>
<tbody>
</tbody>
I have a spreadsheet with a drop down list containing roughly 30 different selections.
When the same selection has been selected multiple times, I ideally want them tallied in
a separate table on the same sheet. The top 5. I want the name of the selection to be copied
over as well as tallying the amount of occurrences. Is this possible?
The spreadsheet looks like this...
... | ... | DROP DOWN LIST |
<tbody>
</tbody>
TITLE | NAME OF ISSUE | OCCURRENCES |
<tbody>
</tbody>
Last edited: