return max in date range based on X column #

%3CLINGO-SUB%20id%3D%22lingo-sub-1283123%22%20slang%3D%22en-US%22%3Ereturn%20max%20in%20date%20range%20based%20on%20X%20column%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283123%22%20slang%3D%22en-US%22%3E%3CP%3Ereturn%20max%20in%20column%20specified%20subject%20to%20date%20criteria.%26nbsp%3B%20Column%20%23%20is%20returned%20in%20e5%2C%20so%20assuming%20e5%20%3D%2010%2C%20dailyworksheet%20has%20dates%20in%20row%20a2%3Aa1000%2C%20i%20would%20want%20the%20max%20of%20the%2010th%20column%20that%20is%20on%20the%20%22daily%22%20tab%20within%20the%20date%20range%20provided%20in%20column%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1283123%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283324%22%20slang%3D%22en-US%22%3ERe%3A%20return%20max%20in%20date%20range%20based%20on%20X%20column%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283324%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609949%22%20target%3D%22_blank%22%3E%40mryno%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20attached%20the%20sample%20file%20with%20your%20desired%20output%20type%20manually.%20This%20will%20help%20us%20to%20understand%20your%20query%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283980%22%20slang%3D%22en-US%22%3ERe%3A%20return%20max%20in%20date%20range%20based%20on%20X%20column%20%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609949%22%20target%3D%22_blank%22%3E%40mryno%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMike%2C%20perhaps%20MAXIFS()%20will%20work%2C%20but%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3Bsaid%20without%20sample%20file%20it's%20hard%20to%20suggest%20something%20concrete.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

2 Replies
Highlighted

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

Highlighted

@mryno 

Mike, perhaps MAXIFS() will work, but as @Faraz Shaikh said without sample file it's hard to suggest something concrete.