kieranjcollins
asked on
Array formula - max date from a range for a specific value
I have attached part of a file I am working on
I have a list of dates and sales assistants on 1 sheet
What I am looking to do is write a formula so that my array formula:
=IF(MAX(IF((Data!B:B<=B6)*
will also look at data values on another column as a condition for doing the max range formula
e,g, I would like Cell C3 to show max date range values for Sales Assist 1 etc
Any help greatly appreciated
Kieran
Array-formula-help.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
=IF(MAX(IF((Data!$B$1:$B$1
=D$1 instead of >=D$1
But other than that, your help was awesome, 500 points to you