Dear all,
From about 30000 values I have to find cells with min and max value (C).
This min and max value are dependent on other two numbers (A and B) which are located in different columns
(but same rows as this min or max value) and which are also important to me.
My problem - I would like to show this two numbers (which causes min and max value of result) in separate cells.
Simple example in attachment.
Thank you and best regards!
Martin
See the sheet.
Basically, it searches for the max/min value in C, then moves over using =OFFSET
Here are the formulas:
Will this work for what you are trying to do?
Please Login or Register to view this content.
Try
In I2 and copy to j2
=INDEX(A$2:A$11,MATCH($E$2,$C$2:$C$11,0))
In I3 and copy to J3
=INDEX(A$2:A$11,MATCH($f$2,$C$2:$C$11,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
for the minimum from C use this
=INDEX($A$1:$C$11,MATCH(MIN($C$2:$C$11),$C$1:$C$11,0),MATCH(I$1,$A$1:$C$1,0))
for the max, use this
=INDEX($A$1:$C$11,MATCH(MAX($C$2:$C$11),$C$1:$C$11,0),MATCH(I$1,$A$1:$C$1,0))
they can both be copied over for B
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Dear all,
the problem is solved.
Thank you!
I appreciate it very much!
I used Fotis1991 solution, because it is the only solution I understood relatively quickly.
In other solutions I couldn't understand some things, but it is related to my poor excel knowledge
-but I will try to find it out.
Best regards
Martin
You are welcome.
Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks