I have a table with 3 columns, Song, Artist and PlayList and I need some additional counting formulas:
1. Formula to count the total number of unique entries in the Artist column.
2. Formula to count the number of unique entries in the Artist column where the first letter of each Artist entry is 'A', 'B', or 'C'.
3. Formula to count the number of unique entries in the Artist column where the first letter of each Artist entry is 'A', 'B', or 'C' AND
the Corresponding entry in the PlayList column is 'X'.
I have attached a sample workbook.
Bookmarks