Support Board

Date/Time: Thu, 26 Jun 2025 09:34:32 +0000

Post From: Spreadsheet Programing - MAX function question

[2021-11-29 19:22:38] Link To Thread - Link To Post [Go To First Post]
User183724 - Posts: 194
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.