May I please request some assistance with some data? My music inventory spreadsheet has a column named Year of Release. If I know the release year of an album, I enter it. If not, I leave it blank.
Is there a way to tally up the years of release, and create a list or something that shows the total number for each year, ranked from most first to least last?
For example, if the year 1969 appears 71 times, and is the year that appears the most frequently in that column, can I create something that looks a little like this:
1969 - 71
1970 - 46
1974 - 44
1975 - 43
1968 - 37
I'd also, if possible, like the option of ignoring or including empty cells.
And so on? Is there a way to do this? If so, what's the most practical method?
Thank you! Jd
Is there a way to tally up the years of release, and create a list or something that shows the total number for each year, ranked from most first to least last?
For example, if the year 1969 appears 71 times, and is the year that appears the most frequently in that column, can I create something that looks a little like this:
1969 - 71
1970 - 46
1974 - 44
1975 - 43
1968 - 37
I'd also, if possible, like the option of ignoring or including empty cells.
And so on? Is there a way to do this? If so, what's the most practical method?
Thank you! Jd