| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return cell address of longest text string in a range
Say I have a range of text strings, A1:A10.
I know I can extract the length of the longest text string in that range by entering the array formula =MAX(LEN(A1:A10)) How can I return the cell address of the longest string? Thanks, Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return the address of the range of plotted data on an XY scatter chart? | Charts and Charting in Excel | |||
| Return a formula as text string to a cell | Excel Worksheet Functions | |||
| Longest string in a column | Excel Worksheet Functions | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
![Dave F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
