It looks to be an ALPHABETIC sort rather than a NUMERIC sort. or.. a Binary sort...
Regardless, that means that 192 comes before 52 because 1 comes before 5 Unfortunately, even if the cells are formatted as Text, Excel tries to sort numbers as Numeric and text gets sorted separately. To get the sort sequence you wanted, I was able to create a column and concatenated the letter "x" in front of each number using: ="x" & A2 then copied it down. By sorting on this column, I was able to achieve the sequence you intended. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Dilip Pandey <dilipan...@gmail.com> To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Cc: sharma....@gmail.com Sent: Fri, October 14, 2011 1:15:27 AM Subject: Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric) Hi, In the Sorted list, you have shown 92C, 94B, 94C... This is not sorted as per alphabet order and neither it is in numeric (Descending) and same goes with 193, 195, 52, 86. Kindly explain the order. Thanks Regards, DILIPandey On 10/14/11, B Sharma <sharma....@gmail.com> wrote: > Dear Don & other experts.... > > Coloumn A has raw data and column B have sorted data > Before After > 52 193 > 86 195 > 92C 52 > 94B 86 > 94B 87 > 195 92C > 193 94B > ABC 94C > XYZ 94J > 87 94K > 94J ABC > 94B XYZ > 94K > 94C > > > Hope that you can understand... > Thanks 7 Regards, > BS > > > > > On Oct 13, 9:01 pm, "dguillett1" <dguille...@gmail.com> wrote: >> What would the AFTER look like >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> >> >> >> >> >> >> -----Original Message----- >> From: B Sharma >> Sent: Thursday, October 13, 2011 8:46 AM >> To: MS EXCEL AND VBA MACROS >> Cc: rajanverma1...@gmail.com >> Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric) >> >> Dear Excel Experts .... (and to my friends who have answered to my >> earlier queries) >> >> From a long time, I am searching for a formula which can sort the list >> and represent the unique datas only >> >> for Example , In column 1 I have the following data >> >> 52 >> 86 >> 92C >> 94B >> 94B >> 195 >> 193 >> ABC >> XYZ >> 87 >> 94J >> 94B >> 94K >> 94C >> >> like this... >> I want a output in column B where it will ignore the duplicate items >> and sorted figures. >> >> I think its quiet difficult.... but please try this ... >> >> Thanks & Regards, >> B. Sharma >> >> -- >> --------------------------------------------------------------------------- >> ------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links >> :http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below >> linkhttp://www.facebook.com/discussexcel > > -- >---------------------------------------------------------------------------------- >- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
