Hello,
I'm using len to return the largest string in a column. What I would like to do is rather than display the amount of characters, actually display the cell data.
The formula I'm using is =max(len(F19:F500))
How can I add to this to display the cell value with the largest string.
Thanks
Rob.
I'm using len to return the largest string in a column. What I would like to do is rather than display the amount of characters, actually display the cell data.
The formula I'm using is =max(len(F19:F500))
How can I add to this to display the cell value with the largest string.
Thanks
Rob.