How to correctly make a formula in Excel the maximum value with a title?

Question

excel

Hello everyone

What formula is needed to automatically determine what is sold the most? in this case, erasers were sold for 800 rubles. THOSE. it is necessary that in one cell the quantity is displayed, and in the other the name of this product
And if possible, immediately the option for the minimum value. Thank you in advance

Answer 1

Answer found
In F4: =MAX(B1:B4)
In E4: =INDEX(A1:A4;MATCH(F4;B1:B4;0))
And that's it. Remove spaces before brackets in formulas!

Answer 2

1. Your one-to-one task is reviewed here:
https://excel2.ru/articles/adres-yacheyki-v-ms-exc... 2. An
eraser is called an eraser . 3. Think about what to do if there are two or more maximum values...