| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel - sort, selected rows??
After the lines
Put instead in G1: =IF(ISNUMBER(MATCH(ROW(A1),{1;3;5},0)),A1-ROW()/10^10,"x") Copy G1 down to G5, as before -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
| SORTING question | New Users to Excel | |||
| Can Excel sort rows by color? | Excel Discussion (Misc queries) | |||
Threaded Mode
