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!
|