Hi
I am having trouble creating a max formula for the attached data.
What I am looking for is a formula which will return the max number in a row specified by the ID# but between a specific date range. E.g. I want the maximum number in the row for 50418141 between 1st October and 31st October, the formula should return 3626.5
All help is appreciated. I have spent a full afternoon trying to figure it out but everything I find relates to looking up based on columns rather than rows.
Thank youHelp.xlsx
Bookmarks