asked on
How Would I Count Different Entries From A Single Excel 2010 Spreadsheet Column
I have an Excel 2010 Spreadsheet that is used for capturing survey data. I have one column in this spreadsheet that has a dropdown menu with three options (Delete, Migrate, Save).
So every cell in that column has one of those three options in it.
I want to be able to count each one of those options seperately from the other two throughout the length of the column.
Any instuction on how to do this would be greatly appreciated.
So every cell in that column has one of those three options in it.
I want to be able to count each one of those options seperately from the other two throughout the length of the column.
Any instuction on how to do this would be greatly appreciated.
Microsoft Applications
Last Comment
Lord_Dragon
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The semi colon behind the range needs to be a comma but otherwise its just what I needed. Much thanks.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for Lord_Dragon's comment #a40074686
for the following reason:
Works like a charm, thank you.
Accepted answer: 0 points for Lord_Dragon's comment #a40074686
for the following reason:
Works like a charm, thank you.
ASKER
Thank you