Hello,
I'm trying to plug in a CHOOSE function that I can use to pull the AVG and MAX rating from my data set. I attached a small sample of what I'm working with to get an idea.
Right now I just want to be able to pull the AVG and MAX from Column C and D. More columns will be added afterwards.
Try this:
Formula:
Please Login or Register to view this content.
choose returns either 1 or 4 to aggregate function #:
Please Login or Register to view this content.
Aggregate(1,6... --> Average
Aggregate(4,6... ---> Max
index(($c$10:$c$19,$d$10:$d$19) will return either column C or D to the aggregate ARRAY parm depending on the results of the Match function (i.e. 1 or 2)
Last edited by protonLeah; 04-03-2025 at 10:06 PM.
Ben Van Johnson
Edited: Simplified.
Similarly in B5Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 04-03-2025 at 08:48 PM. Reason: Simplified previous formula
Dave
=switch(b4,"avg",average,"max",max)(xlookup(b3,c9:d9,c10:d19))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks