Forum Discussion

Copper Contributor

Jun 30, 2023

Solved

Max function for Spilled Range

Hello, I am struggling to resolve the following. With DA (Dynamic Array) formulas I calculate 3 columns: App: =IF(D7=1,INDEX(SORTBY($AF$15#,$AG$15#,-1),SEQUENCE(AJ11)),INDEX(SORTBY($AF$15#,$AG$1...

excel

Formulas and Functions

SergeiBaklan
Jun 30, 2023
Tegzi

As variant

=IF( B2# > C2#, B2#, C2#)

Tegzi

Copper Contributor

Jun 30, 2023

SergeiBaklan

Thanks. Indeed I did not even think that a simple if could handle the spilled range and DA function results...I guess I over complicated. Thanks for the solution.

Best regards,
Tegzi

SergeiBaklan

Diamond Contributor

Jul 01, 2023

Tegzi , you are welcome