VIP
Trusted Members
December 7, 2016
Hello,
Please attach an Excel file instead of pictures, your formulas are referencing columns we don't see in the pictures and not many want to sit and create their own sample data, which may or may not be similar to your data.
There is a nice blog post about this aggregate function, well worth reading.
https://www.myonlinetraininghu.....e-function
As per the help text about this function (https://support.microsoft.com/.....9993fa26df)
Errors:
If a second ref argument is required but not provided, AGGREGATE returns a #VALUE! error.
If one or more of the references are 3-D references, AGGREGATE returns the #VALUE! error value.
Without access to the data I can't really give a better answer.
Br,
Anders
Trusted Members
February 13, 2021
Trusted Members
Moderators
November 1, 2018
March 29, 2020
Thank you for the reply!
Pls check the google sheets. Pls feel free to edit the google sheets, I have given edit access.
https://docs.google.com/spread.....38;sd=true, https://docs.google.com/spread.....38;sd=true
The following users say thank you to Ahamed Shaakir for this useful post:
Mynda Treacy1 Guest(s)