Counting the column contents in the excel

Hi all,

I have an excel dataset (2010) that contains columns like below:

AB
SE
AB
DW
AW
AB
DW
Arabidopsis thaliana AB family, etc.

I would like to have the number of each cell with a given content in the coumns, for example, we have 4 cells with AB, or two cells with DW, and so on. Since the coulmn is so large, the manually counting is impossible, could you please help me out how I can do it?

Thank you in advance

Can you post a sample dataset?

I would use a pivot table, but you CAN use COUNTIF(S). Actually since you want AB to exist anywhere in the string you will likely need sumproduct or countif(s).

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You can use a COUNTIF(S) or SUMPRODUCT like mikeTRON suggested, or you can use a filter and get a count of the number of cells left visible. If you are after like a distribution table of the different entries then the formulas are the way to go. If you are after a one off or infrequent count of just one type of entry I would consider the filter option.

In Cell B2 of the AFTER:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.