In this example, I have four stores that are each selling various categories of items and they each have a total in their respective column. On the right-hand side, I've manually ranked the highest performer to the lowest, based on the total in each store's column.

I typically will copy/paste over the cell's data on a daily basis (so the data changes frequently), but I'm trying to figure out how to have the "Rank" column update automatically, without having to manually change it each time. Essentially, the only rows I care about are Row 1 and Row 8.

Any help is much appreciated!

Looking for a way to pull values from a data table into another sheet. I would like to pull the 5 highest values and the 5 lowest values. not having much luck.

Would also like to pull the corresponding data on the same row if possible.

What the text says. I have a table and data set on different sheets to return results based on a listed name. I used MAXIFS and MINIFS to return highest and lowest score, and xlookup to return the name.

EG I want to know who got the highest and lowest score in Richard’s class Students - Scores: Williams - 100 Grant - 90 Cruise - 80 Shatner - 100 Alba - 79

This will yield Williams as the highest and Alba as the lowest

My issue is when multiple people have the same high or low score in a class

EG Smith Students - Scores: Goggins - 100 Plaza - 100 Robbie - 100

This will tell me that Williams has the highest and lowest score in the class, despite not being a student in Smiths class. What do I need to do to yield the results the way I want?

I don’t have a problem with only 1 person being listed for a high score but if that needs to change in order to list it properly, I can work around it. Thanks!

Hello!

Hoping you all can help me impress my team. Every week during our team meeting we create this list of issues to discuss. Then my manager goes around and asks all 5 of us for the numbers of our top 3 — she writes them down and comes up with an order.

If the items are related to a high-priority product they get pushed to the top of the list, but otherwise, it’s just based on our rankings. But it can be a bit messy when all of our rankings are different, and I think there could be a better way to choose among the options.

I’d like to create a spreadsheet where the team members enter the numbers of the top three issues they’d like to discuss. The spreadsheet would then choose among those and spit out the numbers of the top three issues for the team.

The first thing I tried is a COUNT for each number, but what do in case of a tie?

I’d appreciate any direction you fine folks can offer!