LinkBack URL
About LinkBacks
I am needing to find the max value of an order size by P/N and by Year. A MAXIFS formula would be perfect but I cannot find one.
Attached is a small sample size of my data I need to sort through and with 3500 P/N's
Any thoughts?
I am needing to find the max value of an order size by P/N and by Year. A MAXIFS formula would be perfect but I cannot find one.
Attached is a small sample size of my data I need to sort through and with 3500 P/N's
Any thoughts?
Last edited by Vicarious; 04-25-2017 at 04:25 PM.
Hi Vicarious,
Did you say you wanted to upgrade to Excel version 2016 (or Office 365)? They already have a MaxIfS() in the newer versions.
https://support.office.com/en-us/art...b-9b6376b28883
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
You can do this with an array formula: http://www.utteraccess.com/wiki/MaxIf_-_MinIf_AverageIf
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Use a pivot table
Ben Van Johnson
Here's a non-array formula for D4 copied across and down
=MAX(INDEX('Raw Data'!$C$2:$C$54 * ('Raw Data'!$A$2:$A$54=$A4)*(YEAR('Raw Data'!$D$2:$D$54)=D$3),0))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Awesome ! Four great answers!
I love this forum!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks