Hello!
I have a problem with a formula on Max & Min and automatic sorting when data is updated. In the summary sheet I need to have the nationality with the most number & also the least. If there are more than 1 nationality having the same Maximum number, both nationality should be indicated in the same cell. Same with minimum which should only take values having 1 as the least.
I've attached a spreadsheet with example and the result needed.
Thanks for any help and just let me know if there's any clarification needed.
Bookmarks