Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

maximum width occupied by a value 1

Status
Not open for further replies.
philk12

philk12

Programmer
Dec 29, 2005
20
US
How do I find out maximum width occupied by a value in a column in an XL sheet? I dont have specs(lengths of fields) to build a table, I'm manually evaluating each column length by going through data in the xl sheet.
 
Sort by date Sort by votes
=MAX(LEN(F1:F1000)) array entered using CTRL+SHIFT+ENTER will do it for you if you didnt want to use code.

Regards
Ken..........

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]
----------------------------------------------------------------------------
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
412
bs6600
bs6600
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
293
SkipVought
S
remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
1K
remeng
remeng
grnzbra
  • Locked
  • Question
Set Cell Equal to Selected Value from Dropdown.
Replies
2
Views
195
combo
combo
Andrzejek
  • Question
Formula with & and a single quote 2
Replies
4
Views
599
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top