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.