Avatar of Lord_Dragon
Lord_Dragon
 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.
Microsoft Applications

Avatar of undefined
Last Comment
Lord_Dragon

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Pavel Celba

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Lord_Dragon

ASKER
The semi colon behind the range needs to be a comma but otherwise its just what I needed. Much thanks.
Lord_Dragon

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.
Lord_Dragon

ASKER
Thank you
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes