Hello...
I'm trying to do a 'MAX IF' array... and I THINK I have the formula right, but it's returning a #N/A
This is my forumla - and I am remembering to CSE to exit it, etc.
=MAX(IF($A$3:$A$65536=A4,$Q$3:Q$65536,FALSE))
It should definately have an answer for the line I'm testing it on. I thought it was because the values in Q are dates, but I changed them to be straight values and it still returned a #N/A.
Have I missed something??
I'm trying to do a 'MAX IF' array... and I THINK I have the formula right, but it's returning a #N/A
This is my forumla - and I am remembering to CSE to exit it, etc.
=MAX(IF($A$3:$A$65536=A4,$Q$3:Q$65536,FALSE))
It should definately have an answer for the line I'm testing it on. I thought it was because the values in Q are dates, but I changed them to be straight values and it still returned a #N/A.
Have I missed something??