Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting or Filtering
Can someone please help me? I need to sort a column by the number of
digits...not the amount. Some numbers are 6 digits, 8 digits, and then 14 digits. I need to sort them by the number of digits and not the value. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting or Filtering
=len(trim(a2)) in a helper column
-- Don Guillett Microsoft MVP Excel SalesAid Software "JD" wrote in message ... Can someone please help me? I need to sort a column by the number of digits...not the amount. Some numbers are 6 digits, 8 digits, and then 14 digits. I need to sort them by the number of digits and not the value. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting or Filtering
Can you please elaborate on that for me? I am only familiar with the basics
of Excel. "Don Guillett" wrote: =len(trim(a2)) in a helper column -- Don Guillett Microsoft MVP Excel SalesAid Software "JD" wrote in message ... Can someone please help me? I need to sort a column by the number of digits...not the amount. Some numbers are 6 digits, 8 digits, and then 14 digits. I need to sort them by the number of digits and not the value. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting or Filtering
Say your data is in A2:A#### (headers in row 1).
Insert a new column A (a column to help you do something--therefore, a helper column). Put a nice header in the new A1: Length Then in A2, put Don's formula: =len(trim(a2)) Then drag that formula down as far as you need (matching the amount of data in column B). Then select the entire range and sort your data. Debra Dalgleish has some tips for that formula entry he http://contextures.com/xlDataEntry01.html and using the mouse to drag down the formula he http://contextures.com/xlDataEntry01.html#Mouse JD wrote: Can you please elaborate on that for me? I am only familiar with the basics of Excel. "Don Guillett" wrote: =len(trim(a2)) in a helper column -- Don Guillett Microsoft MVP Excel SalesAid Software "JD" wrote in message ... Can someone please help me? I need to sort a column by the number of digits...not the amount. Some numbers are 6 digits, 8 digits, and then 14 digits. I need to sort them by the number of digits and not the value. Any ideas? Thanks -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting or Filtering
also look for LEN
-- Don Guillett Microsoft MVP Excel SalesAid Software "JD" wrote in message ... Can you please elaborate on that for me? I am only familiar with the basics of Excel. "Don Guillett" wrote: =len(trim(a2)) in a helper column -- Don Guillett Microsoft MVP Excel SalesAid Software "JD" wrote in message ... Can someone please help me? I need to sort a column by the number of digits...not the amount. Some numbers are 6 digits, 8 digits, and then 14 digits. I need to sort them by the number of digits and not the value. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and filtering HELP!!!!! | Excel Worksheet Functions | |||
Sorting/Filtering | Excel Discussion (Misc queries) | |||
sorting and filtering results | Excel Worksheet Functions | |||
sorting and filtering | Excel Worksheet Functions | |||
Sorting and filtering | Excel Worksheet Functions |