How to move rows in a Sheet?

E

Ekser

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

Bob Phillips

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?
 
Top