Thread: sorting in order
View Single Post
  #1   Report Post  
ceemo
 
Posts: n/a
Default sorting in order

i have a column containing names but they are not in an order and have
blank spaces between them. Is there a way they can be sorted in order
into a new column without using the genral sort method.

Ive used the below formula for doing siimilar using numbers but this
does not work for alpha's

=IF(ISNUMBER(SMALL($A$5:$A$12,ROW()-ROW($A$5)+1)),SMALL($A$5:$A$12,ROW()-ROW($A$5)+1),"")


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=383494

Reply With QuoteReply With Quote
 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.
Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.