Hi All
I'll get straight to the point. I have a playlist of tracks that have been played from a playlist over the period of a month, I have the list in excel format and need to use the countif formula to show me the following.
Show me how many times each unique track has been played in that month.
I believe the countif formula is the right one to use but can't work out how to do it. It may be that I have to create a second column to list all the unique tracks from the first column then create a third column showing how many times each has been played, or is this complicating things?
I hope this makes sense, if not let me know and I will try and explain a little better.
Thanks in advance
Nelix
Bookmarks