Show most frequent popup menu selection in Numbers

Hello!

I know Apple Numbers is a bit lacking in some ways so I was wondering if it is even possible to achieve what I am looking do to.

I have created a reading journal where I have a column to select a book’s genre from a popup menu.

What I would like to do is create a separate cell that would display the option/genre that is has been selected the most (Fantasy from my screenshot above).

I’d like the highlighted cell to show “🐉 Fantasy”.

I already know how to create a secondary table to sum the number of times each choice is selected, but is what I’m looking for possible to do?

Any help would be greatly appreciated!

Thank you!