sorting values
I would like to use a formula to copy all the values from a range (in a
column) to the next column, at which time they are sorted from high to low. This way I can see the originial data side by side with the sorted data. |
sorting values
Numbers in A1:A20.
Enter this in B1, and copy down: =SMALL(A$1:A$20,ROWS($1:1)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Suzuki" <Suzuki @discussions.microsoft.com wrote in message ... I would like to use a formula to copy all the values from a range (in a column) to the next column, at which time they are sorted from high to low. This way I can see the originial data side by side with the sorted data. |
sorting values
SORRY !
That was Low to High. This is for High to Low: =Large(A$1:A$20,ROWS($1:1)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Suzuki" <Suzuki @discussions.microsoft.com wrote in message ... I would like to use a formula to copy all the values from a range (in a column) to the next column, at which time they are sorted from high to low. This way I can see the originial data side by side with the sorted data. |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com