Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Longest Entry in Columns
Hi. What is the best / quickest way to find the longest entry (most
characters / numbers, etc.) in a column? Thanks. |
#2
|
|||
|
|||
Hi!
This array formula entered with the key combo of CTRL,SHIFT,ENTER will tell you how long the longest entry is in a range of cells: =MAX(LEN(A1:A100)) If you want to identify that entry, you could use conditional formatting: Select the range A1:A100 Goto FormatConditional Formatting Formula is: =LEN(A1)=MAX(LEN(A$1:A$100)) Click the Format button and select a background fill color OK out Biff -----Original Message----- Hi. What is the best / quickest way to find the longest entry (most characters / numbers, etc.) in a column? Thanks. . |
#3
|
|||
|
|||
P.S. -
If you want the longest entry in a range of cells to be returned in a formula: Array entered with the key combo of CTRL,SHIFT,ENTER: =INDEX(A1:A100,MATCH(TRUE,LEN(A1:A100)=MAX(LEN (A1:A100)),0)) If more than one cell contains the longest entry the formula will return the first instance of the longest entry. Biff -----Original Message----- Hi. What is the best / quickest way to find the longest entry (most characters / numbers, etc.) in a column? Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |