View Single Post
  #1   Report Post  
John O'brien
 
Posts: n/a
Default how do you delete blank rows in a spreadsheet using an "if" funct

what syntax is correct in the false part of an "if" statement to delete a
blank row...eg =if( a1= "Tom", B1,{ what goes here to delete the row so as
blank rows are not returned}