Results 1 to 5 of 5

Deleting unwanted data from a sheet.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Deleting unwanted data from a sheet.

    I am looking for a solution to remove any row without data in Column E of the attached file.
    If an entry appears in column E then I require all data in that row kept.
    It is a bit like sorting data by column E and if nothing in Column E, then delete entire row.
    If a sort function can be undertaken, then sort by column A.
    I have deleted data that usually appears in columns A and B for privacy.
    Attached Files Attached Files
    Last edited by Christopherdj; 05-03-2012 at 10:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1