How can I determine the largest physical size cell in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a worksheet in which I need to know the largest size item in each
column, text coulmns only.
 
=MAX(LEN(A1:A1000))
Array formula, to be validated with Ctrl+Shift+Enter


HTH
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
Automatic Sorting? 6
How to get largest date from a Vlookup 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I search for the second largest value in the array? 1
how do I get the last entered value in a column of values 12
Find Smallest and Largest. 5
Finding the largest match 9

Back
Top