Have "most common names in a list" update as users add to list?

[bmsmith311]

I have a spreadsheet where readers keep track of their books for the year. I wanted to create a way for them to see who their most common audiobook narrators are. I have successfully made a list and also used a pivot table to count and organize the data.... but it doesn't seem to update if I add new names to this list. Anything new would be included in the formula and I need this to be able to automatically update because people will be entering their own data all year long. Any suggestions why this isn't happening (if it should be) or if that's even possible? I figured the pivot table would update as new data was entered but it doesn't seem to be doing so.

Thank you for any help!

 

[bmsmith311]

I have a spreadsheet where readers keep track of their books for the year. I wanted to create a way for them to see who their most common audiobook narrators are. I have successfully made a list and also used a pivot table to count and organize the data.... but it doesn't seem to update if I add new names to this list. Anything new would be included in the formula and I need this to be able to automatically update because people will be entering their own data all year long. Any suggestions why this isn't happening (if it should be) or if that's even possible? I figured the pivot table would update as new data was entered but it doesn't seem to be doing so.

Thank you for any help!

I googled and answered my own question.... can't find a way to delete my post