Not really sure where to post this but i will try here first.
I am trying to make an organized, nice looking list to my spreadsheet.
I have about 40-50 tabs with 14 names listed in each tab. The names can and will change over time.
On the 1st page i would like to count how many times each name appears throughout all the tabbed pages and rank them in order of most to least.
heres how i did it:
link a column on the 1st page to each name in every tab on the list
next column is paste of values only
next column changes all to lower case
next column sorts by unique values only
next column takes quantity of names from 1st column based off unique name
It does not work to well, i cannot sort by rank and it does not seem to be dynamic.
Any help would be greatly appreciated