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.