Deleting empty rows.
Posted by Leon Miller on March 13, 2001 5:48 AM
I have a spreadsheet that has a load of formula in that when data get copied in works, however i need to have formula in mor cells than data at the moment, in case of expansion. However when i sort it all of these blank rows come out on top, as they arent really blank. Any help with what i can do. Ive tried to use the sort help from george on the 05/03/01 but this wont work ad the rows are not empty. Help
Posted by Leon Miller on March 13, 2001 5:54 AM
Sorry, ive used the thelp given to A.R. on the 09/03/01, this is what wont work for me.
Posted by Dave Hawley on March 13, 2001 7:58 PM
Hi Leon
Lets say your formulas are in Column A in Column B put: =IF(A1="","z",A1)
Then simply sort Columns A&B by Column B
Dave
OzGrid Business Applications
Posted by Dave Hawley on March 14, 2001 4:39 AM
You will need to supply me with some more detail if you want a solution, starting with why the formula I suggested wont work for you.
Dave
OzGrid Business Applications
Posted by Leon Miller on March 16, 2001 1:45 AM
Well it does work but when i sort on the sheet, it still find data something in the rows, although they are actually empty. I have no idea why.
