Combining/Grouping Cell/Row information

Hi,

I have a need to deduce the quantity of cells in a specific row that contain identical information. I don't think a "=COUNTA" will work since there are multiple options.

Row A will have cells like this
STD
STD
CC
CC
STD
FL
CC
STD
FL
EPX
CC
STD

I'd like as few cells as possible to generate the following information:
4 Types
5 STD
4 CC
2 FL
1 EPX

I could have up to 8 different types of "stuff" in these cells.

Good day,


Assuming all your data is in Column A, use COUNTIF instead of COUNTA. e.g.
=COUNTIF(A:A,"STD")&" STD";
=COUNTIF(A:A,"CC")&" CC"

Thanks Ace,

I need to improve my communication skills.

I was looking for something more "automated"

I am looking for excel to establish the various types based on the information in the row. Then establish how many of each type.

I need this to be fairly dynamic, I am importing from a data base and occasionally a new Type is added. I would like it if I did not have to modify the excel spreadsheet with new data.

With the recorded macro in this file.

Push the button to run the macro.

Please reply if this is what youre up to.

Please Login or Register  to view this content.

Yes, that worked perfectly. Thanks!