Looking for a way to “Lookup” a value within categories based on a Min or Max value. For example: I am building a worksheet to keep track of race times. There are different categories of racers. I have a summary range that tracks fastest time within categories, etc. I want to be able to draw out the name (or names, if there is a tie) of the individuals who have the fastest times. This would involve some creatives use of the Lookup function. Evidently, I am not creative enough to figure it out on my own.
For the simplicity of documenting times during the races, I am trying to keep all racers on one list, instead of dividing them by categories on different sheets. However, this makes for more complex formulas. If need be, I can divide them up, but thought I’d ask if anyone can do this as a single list.
Any suggestions would be greatly appreciated.
