Hi Experts!
Looking for a help from you guys.
I am working on Office 365.
I have a table with a value for different months for different projects, and the projects has 3 types.
My selection criteria is "Month" and "type of Project" which are dynamic.
Once the selection is done, the result need is the highest values of the project for the selected month.
Since my end result will be in other sheet, I need to show the corresponding project which is match to the resulted value with.
I have tried many ways with Index-match-large function, but could not completed.
I am not particular with Index-match-large formula. I am ok with any formula which will make the end result looking for.
I have attached a sample file, and shown the required result needed (Done manually).
In the attached file, yellow cells are my selecting criteria and blue cells are the ones I would get the result in by formula.
Thanks in Advance
Bookmarks