Hello
Can someone please help me with the following
If I have a single excel column where each cell can contain one of a few text values as follows. I want another blank column to total up each item for example total text1 = 4, total text2 = 3, total text3 = 3
text1
text2
text1
text3
text3
text2
text1
text1
text2
text3
can someone please assist me with this
Thanks in advance
Charlie
Bookmarks