Hi, I hope there's someone who can help me on this problem.
I need to get the maximum value after satisfying multiple search criteria. Below is the scenario
Search criteria are:
1. Look at column A for items that matches in cel G
2. Column B must not be empty (greater than 0)
Result to display must be the maximum value at column C after satisfying above both criteria.
See attached. Expected output are in column H, highlighted in red.
Please help to create the correct formula to get the expected output.
Bookmarks