Apr 05 2020 03:39 PM
return max in column specified subject to date criteria. Column # is returned in e5, so assuming e5 = 10, dailyworksheet has dates in row a2:a1000, i would want the max of the 10th column that is on the "daily" tab within the date range provided in column A.
Thank you,
Mike
Apr 05 2020 06:24 PM
Hi @mryno
Please attached the sample file with your desired output type manually. This will help us to understand your query correctly.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Apr 06 2020 01:37 AM
Mike, perhaps MAXIFS() will work, but as @Faraz Shaikh said without sample file it's hard to suggest something concrete.