hello guys,
I know how to find maximum and minimum, but how could I write cell value with maximum and minimum value?
I think more understandable will be to upload sample file
thanks for any help!
hello guys,
I know how to find maximum and minimum, but how could I write cell value with maximum and minimum value?
I think more understandable will be to upload sample file
thanks for any help!
Last edited by miso.dca; 01-21-2018 at 04:40 AM.
Try...
K8 =MAX(IF($A$2:$A$14=K7,$E$2:$E$14))
L8 =MIN(IF($A$2:$A$14=L7,$H$2:$H$14))
IMPORTANT
- This is an array formula
- Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
- If entered correctly, the formula will be enclosed in {brackets}
- Do not enter the {brackets} manually
HTH
Regards, Jeff
Dear miso.dca
Here is the macro that will render your desired output.
Please Login or Register to view this content.
jeffreybrown - thx, but your solution (at least for me) doesnt work, the result is number and not cell from A column ... (or did i do something wrong? array formula was there)
rcm - your solution works perfectly thanks
anyway if anybody has formula (sorry I create this thread in bad forum) for my problem, just let me know
if not, I will mark it tomorrow solved thanks guys
Not sure if I'm missing something, but in your sample workbook you are looking to return 155 for the max of slivka and 175 as the min for jablko.
yes, that's correct, but I dont need to return "155" but "slivka"
and your formula returns only "155" or am I missing something?
Yes, sorry mis-read what you were asking...
K7 =INDEX(A2:A14,MATCH(MAX(E2:E14),E2:E14,0))
L7 =INDEX(A2:A14,MATCH(MIN(H2:H14),H2:H14,0))
These are normal formulas. No need for CSE
yeah! that's it thank you very much jeffreybrown
I will HAVE to learn how to do such a tricky formulas I know very little from this area ... again, thank you
You are very welcome and thanks for the rep.
Here is a reference you might find useful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks