View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rothman Rothman is offline
external usenet poster
 
Posts: 26
Default Sorting by Row Number?

Can you sort a row by row numbers in the formulas of the values of the cells?

For instance, I have a 120x5 table which looks like this:


=K301 =L302 =M303 =N304 =O305
=K301 =L302 =M303 =N305 =O304
=K301 =L302 =M304 =N303 =O305
=K301 =L302 =M304 =N305 =O303
=K301 =L302 =M305 =N303 =O304

....and so forth

I'd like to sort the rows in my table by the row numbers indicated, like so:

=K301 =L302 =M303 =N304 =O305
=K301 =L302 =M303 =O304 =N305
=K301 =L302 =N303 =M304 =O305
=K301 =L302 =O303 =M304 =O305
=K301 =L302 =N303 =O304 =M305

...and so forth.

Can this be done?

Thanks again!