Sort number small to big

S

sunwordelite

New Member
Joined
Sep 7, 2009
Messages
15
Hello sir need formula for using non vba .example image attach .I need to sort number smallest to largest in cell A2 to B2
4digit in single cell '5 digit and 6 digit in...
 

Attachments

  • Screenshot_2020-12-08-22-45-18-532_cn.wps.moffice_eng.jpg
    Screenshot_2020-12-08-22-45-18-532_cn.wps.moffice_eng.jpg
    146.8 KB · Views: 8
Sort by date Sort by votes
sunwordelite said:
Wait si

Sir I try first thanks for reply
Click to expand...

Fluff said:
Ok, how about
+Fluff v2.xlsm
BC
10987321123789
114096832101234689
12406046
Master
Cell Formulas
RangeFormula
C10:C12C10=TEXT(SUM(SMALL(--MID(B10,ROW(INDIRECT("1:"&LEN(B10))),1),ROW(INDIRECT("1:"&LEN(B10))))*10^(LEN(B10)-ROW(INDIRECT("1:"&LEN(B10))))),REPT("0",LEN(B10)))
Press CTRL+SHIFT+ENTER to enter array formulas.


Please don't forget to update your account details & then scroll down & click Save.
Click to expand...
 

Attachments

  • Screenshot_2020-12-11-00-22-30-543_cn.wps.moffice_eng.jpg
    Screenshot_2020-12-11-00-22-30-543_cn.wps.moffice_eng.jpg
    142.6 KB · Views: 4
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
In post#5 click on the copy icon (left of B & above 10) then paste that into B10 on your sheet.

1607617844175.png
 
Upvote 0
Re post#14, you have already answered that question. Please stop duplicating your posts.
Also stop quoting your own posts, it makes no sense.
Who are you talking to in post#13?
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Find the First Number In a Table of Sorted Numbers That is Smaller Than Another Number
Replies
4
Views
96
Eb0la11
E
E
  • Question
Dynamic small function
Replies
1
Views
190
KRice
K
L
  • Question
Step 1: Can you Loop Through Multiple Excel worksheets in one workbook (Copy and paste all to new worksheet or Workbook)
Replies
9
Views
410
Micron
M
N
  • Question
Index Match after sorting
Replies
1
Views
273
Eric W
Eric W
M
  • Question
Sorting/applying forumal to same column
2
Replies
15
Views
856
Alex Blakenburg
A

Forum statistics

Threads
1,214,932
Messages
6,122,332
Members
449,077
Latest member
jmsotelo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top