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
