Hi,
I am trying to create a LARGE formula that will return in descending order the values in column A that meet two criteria:
The word in the adjacent cell in column B is not “apple” and the word in the adjacent cell in column C is “summer”.
My unsuccessful effort is shown in E1:E2. If the formula was working as required it would return 3 and 2, respectively.
Can someone please suggest a solution.
Thanks
Bookmarks