Sort feature
|
Sort feature
Hello, CLR!
You wrote on Mon, 8 Jan 2007 09:31:01 -0800: C =LEN(A1) C Then do copy PasteSpecial Values on that helper C column....... C then sort on the helper column, ascending It seems to work without the Paste Special complication :-) C " wrote: ?? I have a column of names. I want to be able to sort that ?? column from smallest name to largest name. In other ?? words, Al, sam, dave, brian, george, michael....etc. ?? ?? Can anyone help me? ?? ?? Thank you in advance, ?? Michael ?? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Sort feature
Cool......thanks for pointing that out.........I didn't check it, I just
don't like leaving formulas laying around.....<g Vaya con Dios, Chuck, CABGx3 "James Silverton" wrote: Hello, CLR! You wrote on Mon, 8 Jan 2007 09:31:01 -0800: C =LEN(A1) C Then do copy PasteSpecial Values on that helper C column....... C then sort on the helper column, ascending It seems to work without the Paste Special complication :-) C " wrote: ?? I have a column of names. I want to be able to sort that ?? column from smallest name to largest name. In other ?? words, Al, sam, dave, brian, george, michael....etc. ?? ?? Can anyone help me? ?? ?? Thank you in advance, ?? Michael ?? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
All times are GMT +1. The time now is 08:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com