Longest Entry in Columns
Hi. What is the best / quickest way to find the longest entry (most
characters / numbers, etc.) in a column? Thanks. |
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. . |
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. . |
All times are GMT +1. The time now is 03:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com