Support Board

Date/Time: Tue, 04 Mar 2025 11:22:02 +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: 191
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.