Need some help with a unique list. I have data in 3 columns as shown below
Names Year Rank John 2020 1 Kevin 2021 5 Mary 2022 4 Ann 2021 3
i want a unique table for each year, to show the Names, but in rank order, as shown below
what formula should i put in first cell (i.e. where John is)? I am able to get this table but without rank order, and i can get a 1 column table with all of the unique names in rank order, just can't figure out how to combine :/
2020 2021 2022 John Ann Mary Kevin
Bookmarks