The concept seems simple to me, but I'm unable to get the right syntax.
I am trying to find the top 3 values in Column C, so long as Column A is less than 6 years away and Column B is less than 100.
I have attached a picture of the cell format I'm using because I am unable to paste a table format into this window for some silly reason.
061112 EXCEL FORUM.jpg
I tried this, but it didn't work:
=LARGE(IF(A1<(NOW()+2190),C2:C5),1)
=LARGE(IF(A1<(NOW()+2190),C2:C5),2)
=LARGE(IF(A1<(NOW()+2190),C2:C5),3)
(I obviously hadn't tried adding a condition for Column B because I was unable to solve the first condition of the date being less than 6 years away)
Thanks
mmi
Bookmarks