Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
Hi
I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
Saskitan,
I may have not understood correctly but you don't need a formula for this. Select your column and then Data|sort|Column A|Ascending and click OK. Mike "Sasikiran" wrote: Hi I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
Mike,
I have a list of values autogenerated by formula in a range of row for suppose (A1:Z1). I need a formula which checks the range A1:Z1 and should sort the values in descending order and listed automatically in a column for suppose C3:C26 Sasikiran "Mike H" wrote: Saskitan, I may have not understood correctly but you don't need a formula for this. Select your column and then Data|sort|Column A|Ascending and click OK. Mike "Sasikiran" wrote: Hi I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
In C3 enter this formula then drag down to C26
=INDEX($1:$1,ROWS($1:1)) Now sort row 1.........DataSortOptionsSort left to right. Gord Dibben MS Excel MVP On Mon, 4 Jun 2007 08:10:01 -0700, Sasikiran wrote: Mike, I have a list of values autogenerated by formula in a range of row for suppose (A1:Z1). I need a formula which checks the range A1:Z1 and should sort the values in descending order and listed automatically in a column for suppose C3:C26 Sasikiran "Mike H" wrote: Saskitan, I may have not understood correctly but you don't need a formula for this. Select your column and then Data|sort|Column A|Ascending and click OK. Mike "Sasikiran" wrote: Hi I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
Gord,
I have given the formula but its giving me a error #REF! The formula I have used is =INDEX(B51:K51,ROWS(B55:B65)) Have I given the formula wrong? Sasikiran "Gord Dibben" wrote: In C3 enter this formula then drag down to C26 =INDEX($1:$1,ROWS($1:1)) Now sort row 1.........DataSortOptionsSort left to right. Gord Dibben MS Excel MVP On Mon, 4 Jun 2007 08:10:01 -0700, Sasikiran wrote: Mike, I have a list of values autogenerated by formula in a range of row for suppose (A1:Z1). I need a formula which checks the range A1:Z1 and should sort the values in descending order and listed automatically in a column for suppose C3:C26 Sasikiran "Mike H" wrote: Saskitan, I may have not understood correctly but you don't need a formula for this. Select your column and then Data|sort|Column A|Ascending and click OK. Mike "Sasikiran" wrote: Hi I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
What happened to A1:Z1 range and C3:C26?
Where is the original data and where do you want it placed for sorting? You cannot write the formula as you have tried. Must be single row reference only, not ranges. Gord On Wed, 6 Jun 2007 06:34:01 -0700, Sasikiran wrote: Gord, I have given the formula but its giving me a error #REF! The formula I have used is =INDEX(B51:K51,ROWS(B55:B65)) Have I given the formula wrong? Sasikiran "Gord Dibben" wrote: In C3 enter this formula then drag down to C26 =INDEX($1:$1,ROWS($1:1)) Now sort row 1.........DataSortOptionsSort left to right. Gord Dibben MS Excel MVP On Mon, 4 Jun 2007 08:10:01 -0700, Sasikiran wrote: Mike, I have a list of values autogenerated by formula in a range of row for suppose (A1:Z1). I need a formula which checks the range A1:Z1 and should sort the values in descending order and listed automatically in a column for suppose C3:C26 Sasikiran "Mike H" wrote: Saskitan, I may have not understood correctly but you don't need a formula for this. Select your column and then Data|sort|Column A|Ascending and click OK. Mike "Sasikiran" wrote: Hi I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for sorting a range of cells in decending order
Hi,
I have tried using the formula but it is showing an error #REF! The formula I have used is =INDEX(B51:K51,ROWS(B55:65)) Please let me know if I have entered anything wrong? Sasikiran "Gord Dibben" wrote: In C3 enter this formula then drag down to C26 =INDEX($1:$1,ROWS($1:1)) Now sort row 1.........DataSortOptionsSort left to right. Gord Dibben MS Excel MVP On Mon, 4 Jun 2007 08:10:01 -0700, Sasikiran wrote: Mike, I have a list of values autogenerated by formula in a range of row for suppose (A1:Z1). I need a formula which checks the range A1:Z1 and should sort the values in descending order and listed automatically in a column for suppose C3:C26 Sasikiran "Mike H" wrote: Saskitan, I may have not understood correctly but you don't need a formula for this. Select your column and then Data|sort|Column A|Ascending and click OK. Mike "Sasikiran" wrote: Hi I have different values autogenerated by formula in a range of cells for suppose A1:Z1. I need to know a formula for sorting the range (A1:Z1) and getting displayed in descending order in a column of cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and Eliminating Blank Cells in Formula range | Excel Worksheet Functions | |||
Auto generate numbers in decending order in a column | New Users to Excel | |||
Sorting a range of cells that get value from other cells | Excel Discussion (Misc queries) | |||
linking cells and assort decending | Excel Discussion (Misc queries) | |||
Order Data in Pivot Table Non ascending or Decending | Excel Discussion (Misc queries) |