Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 13:38:06 +0000



Post From: Spreadsheet functions INDIRECT & CONCATENATE examples

[2016-06-27 16:57:36]
User316362 - Posts: 210
I agree. This would be nice to have. I can create a dynamic range and convert it to text but cannot find a way to work around the INDIRECT limitation of using just a cell reference. Any alternative ways to handle this?

for instance MAX(INDIRECT("AK1:AK10")) will not work.

I did find a workaround. So nevermind
Date Time Of Last Edit: 2016-06-27 17:07:27