| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting question | New Users to Excel | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) | |||
Threaded Mode
