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

M

maratmd2019-03-15 11:58:23

excel

maratmd, 2019-03-15 11:58:23

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

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

M

maratmd, 2019-03-15
@maratmd

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!

J

John Smith, 2019-03-15
@ClearAirTurbulence

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...