Greenies08
New Member
- Joined
- Apr 4, 2011
- Messages
- 22
My bad - I was not using the array!! Solved myself
Hi there, pretty sure this is going to be easy but it has me beat for the day.
I want to use the max function for column C if the month in cell L1 matches those in Column A and Column D equals 5000 (or any other value of my choosing)
=MAX(IF((MONTH($A$1:$A$5000)=MONTH(L$1))*($D$1:$D$5000=5000),$C$1:$C$5000))
Really appreciate everyone's time.
Hi there, pretty sure this is going to be easy but it has me beat for the day.
I want to use the max function for column C if the month in cell L1 matches those in Column A and Column D equals 5000 (or any other value of my choosing)
=MAX(IF((MONTH($A$1:$A$5000)=MONTH(L$1))*($D$1:$D$5000=5000),$C$1:$C$5000))
Really appreciate everyone's time.
Last edited: