Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 13:41:31 +0000

How to Post a Message for Support

Post From: Spreadsheet Programing - MAX function question

[2021-11-29 19:22:38]
[Go To First Post]
User183724 - Posts: 183
Spreadsheet MAX function question

Can MAX accept calculated ROW numbers? I have a calculated ROW values in columns BM3 and BN3

I'd like to get the MAX high value of C column (highs) using the values in BM3 and BN3

I've tried:

=MAX(C(BM3):C(BN3))

=MAX(INDIRECT(CONCATENATE("C",BM3)):INDIRECT(CONCATENATE("C",BN3)))

no luck... any assistance appreciated.