MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.