Return the longest string in a column
INDEX)A1:A10, MATCH(MAX(LEN(A1:A10)), LEN(A1:B5),0), 1)
does not work with multiple columns
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top
INDEX)A1:A10, MATCH(MAX(LEN(A1:A10)), LEN(A1:B5),0), 1)
does not work with multiple columns