Hello,
I need a formula for Ascending & Descending Number within a Cell
For Example :
A1: 6249
A2 : Ascending : 2469
A3 : Descendig : 9642
another one :
A1 : 3576
Ascending : 3567
Descending : 7653
Thank you in advance for your reply
Hello,
I need a formula for Ascending & Descending Number within a Cell
For Example :
A1: 6249
A2 : Ascending : 2469
A3 : Descendig : 9642
another one :
A1 : 3576
Ascending : 3567
Descending : 7653
Thank you in advance for your reply
Last edited by soubasa; 05-08-2020 at 08:14 AM.
Here is an array formula, number to order is in D3.
=TEXTJOIN("",TRUE,LARGE(--MID(D3,ROW(A1:INDEX(A:A,LEN(D3))),1),ROW(A1:INDEX(A:A,LEN(D3)))))
Change LARGE to SMALL to get reverse order
Please try at
A2
=SUMPRODUCT(LARGE(--MID(A1,{1,2,3,4},1),{1,2,3,4})*10^{0,1,2,3})
A3
=SUMPRODUCT(small(--MID(A1,{1,2,3,4},1),{1,2,3,4})*10^{0,1,2,3})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks