Excel Question
Hi
I have a spreadsheet with a column that has initials entered ie like AB AC AD or combination AB/AC AC/AD
Is ther a function that will count each time an entries appears IE in column there would be
AB
AC
AD
AB/AC
AC/AD
So totals would be
AB = 2
AC = 3
AD = 2
Many thanks for your time
Mike
|