The next problem requiring solving is:
column I & J present the predictions, I want to first find the highest value in the two columns and then present the contents of the cell 2 to the left - so if column I has the highest value from I & J I want to present the contents of column G, alternatively if column J has the highest value I want to present the contents in Column H
you can find highest value by using Max function
Please upload the sample file for more clarification
Please Login or Register to view this content.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
There might be a simpler way to do it but...
Formula:
Please Login or Register to view this content.
Note that if the MAX value exists in more than one cell, this formula will stop at the first instance of it.
Last edited by EchoPassenger; 09-18-2016 at 12:27 PM.
Is it possible that both columns might have the max value?
If so, what should happen?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
yes, if the 2 columns carry the same value then ideally I would like the word 'Draw' to be displayed but that might be asking too much
Last edited by paulr0700282; 09-18-2016 at 01:09 PM.
EchoPassenger - I don't need to find the highest value in the whole column, just in 2 cells, for example, I4 and J4, find highest, then present content of cell 2 to the left so that would be cell H4 should J4 be the highest
Thank you all for your support
That is possible also. Just make some modification to the formula of EchoPassenger as below :
Please Login or Register to view this content.
WOW - sensational, how do you actually learn how to do this? amazing, Thank you, EchoPassenger & Sanram, I took the latest formula from your goodself Sanram and amended to specific cells - hey presto
=IF(LARGE(I4,1)=LARGE(J4,1),"Draw",IFERROR(INDEX(G4,MATCH(MAX(I4:J4),I4,0)),INDEX(H4,MATCH(MAX(I4:J4),J4,0))))
If it's just the MAX per row the formula is much simpler...Originally Posted by paulr0700282
Formula:Please Login or Register to view this content.
You are welcome and thanks for the rep. You have learnt this too now and will be able to solve such problem by yourself next time. I have learnt this in the same way too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks