Hey Guys,
I got a tricky problem which I cannot solve by myself. I got a table with entries in rows which start with 4 letters. The numbers of rows starting with the same letters varies. I need to know how much rows start with the same 4 letters. A my table contains over 500 rows it would be very handy if excel did it automatically. In my table the letters do not follow any logical algorythm - they are abbreviations.
WXYZ001 1 0 4 WXYZ002 2 6 0 ABCD001 1 1 0 ABCD002 2 5 2 ABCD003 4 5 7 ABCD004 2 3 5 ABCD005 3 4 6 HIJK001 1 2 5
This is what I would like to see:
WXYZ 2 ABCD 5 HIJK 1
Thanks in advance,
Greetings
Bookmarks