Have a worksheet in which I need to know the largest size item in each column, text coulmns only.
C csa001 Jun 22, 2006 #1 Have a worksheet in which I need to know the largest size item in each column, text coulmns only.
A Ardus Petus Jun 22, 2006 #2 =MAX(LEN(A1:A1000)) Array formula, to be validated with Ctrl+Shift+Enter HTH
S SteveG Jun 22, 2006 #3 Do you mean the highest number of characters? Try, =MAX(LEN(A1:A100)) This is an array formula so commit with Ctrl-Shift-Enter not jus enter. It should look like this after commiting, {=MAX(LEN(A1:A100))} Does that help? Stev
Do you mean the highest number of characters? Try, =MAX(LEN(A1:A100)) This is an array formula so commit with Ctrl-Shift-Enter not jus enter. It should look like this after commiting, {=MAX(LEN(A1:A100))} Does that help? Stev
