Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to move rows in a Sheet?
Hi, I'm trying to do the following: If a cell in a row has a certain value (always the same), it should move to the bottom of the sheet (after the last row). If it has another value, it should move on the top of the row. How to do this? Thanks! -- Ekser ------------------------------------------------------------------------ Ekser's Profile: http://www.excelforum.com/member.php...o&userid=11400 View this thread: http://www.excelforum.com/showthread...hreadid=469096 |
#2
|
|||
|
|||
Why not simply add a helper column with a simple formula to return TRUE or
FALSE if that value is present, and then sort on the helper column? -- HTH Bob Phillips "Ekser" wrote in message ... Hi, I'm trying to do the following: If a cell in a row has a certain value (always the same), it should move to the bottom of the sheet (after the last row). If it has another value, it should move on the top of the row. How to do this? Thanks! -- Ekser ------------------------------------------------------------------------ Ekser's Profile: http://www.excelforum.com/member.php...o&userid=11400 View this thread: http://www.excelforum.com/showthread...hreadid=469096 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
Hid rows in a hidden sheet. | Excel Discussion (Misc queries) | |||
How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
make a macro to move specific rows to another sheet | Excel Worksheet Functions |