hi,
i want to sort data first Big numbers then sort data small numbers a2z...if range("g2") is greater then 800
sampo.JPG
thank you
hi,
i want to sort data first Big numbers then sort data small numbers a2z...if range("g2") is greater then 800
sampo.JPG
thank you
Last edited by HaroonSid; 02-02-2018 at 10:35 AM.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Do you mean G2> 800?
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Yes g2 > 800
sorry
At any rate, it's probably easier to do it using formula.
in E5:= RANK(D5,$D$5:$D$26,1)+($G$2>800)*(D5<=800)*1000
Copy down.
Select D5:E26 and sort smallest to largest on E.
You could do it using macro as blow.
Please Login or Register to view this content.
thank you
is it not possible without helping column
You could. Just sort ascending on column D.
Cut range > 800 and insert it above smaller numbers.
Did'nt get sir
how to ?
...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks