Jul 25 2022 03:16 PM
In a row array of cells, I need a formula that selects the last data cell with data in the array? In this example would return a result of 3.
Thank you in advance!
Jul 26 2022 01:05 AM
@GMckown
It could be
=LOOKUP(1E+38,array,array)
Jul 26 2022 03:03 AM
Or even
=LOOKUP(1E+38,array)
Jul 26 2022 05:09 AM
@Hans Vogelaar
Oh, sure, sorry