Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Problem: In columns A5:B100 I have text. In columns C5:BK100 I have either numerical data or empty cells. What I would like to do is filter out and delete those rows where all of the cells in each row in the range C5:BK100 are empty. For example, if all of the cells in the range C6:BK6 are empty, I would like to delete the whole row, including A6:B6. However, if any of the cells in the range C6:BK6 contain data (i.e., are not empty) I do not want to delete the row.
    I tried filtering each column individually, but that doesn't work. Any ideas?
    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In cell BL4, enter a column header, e.g. CountCells.
    In cell BL5, enter the formula =COUNT(C5:BK5)
    Fill down to BL100.
    Click in BL4 and turn on AutoFilter.
    Select 0 from the dropdown list.
    This will hide the rows that contain at least one numeric value in columns C:BK.
    Delete the visible rows from 5 to 100.
    Turn off the AutoFilter.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    So very simple-thanks Hans

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •