Hi and thanks for helping me out!
I have track titles in column A, and I would like a formula or formulas that will let me know what track titles are present in this column and the number of their occurrences.
Example:
A1: Track Titles
A2: Cool
A3: Here We Go
A4: That Title
A5: Cool
A6: Nice
A7: That Title
So I'd like a formula or formulas that would tell me:
Cool (2)
That Title (2)
Here We Go (1)
Nice (1)
Of course, I won't know the track titles in advance...So I can't say 'search for this specific text' etc...
I have track titles in column A, and I would like a formula or formulas that will let me know what track titles are present in this column and the number of their occurrences.
Example:
A1: Track Titles
A2: Cool
A3: Here We Go
A4: That Title
A5: Cool
A6: Nice
A7: That Title
So I'd like a formula or formulas that would tell me:
Cool (2)
That Title (2)
Here We Go (1)
Nice (1)
Of course, I won't know the track titles in advance...So I can't say 'search for this specific text' etc...