I'm trying to create a dynamic list (column I) that will populate based off the sorted city (column F) and the count (column G) - I think i figured out the sorting part (columns E-G) and I currently typed in the dynamic list in column I but I'm hoping someone can help me create a formula that will update the dynamic list if the store count or sorted cities change. Thank you!!!
Sorted List Example.xlsx
Bookmarks