+ Reply to Thread
Results 1 to 7 of 7

delete row based on criteria

Hybrid View

  1. #1
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: delete row based on criteria

    You could use VBA for sure but on the off chance it's a one off you could equally just insert a helper calc, eg:

    B1: 
    =IF(EXACT(UPPER(LEFT(A1;3));LEFT(A1;3))*(MIN(FIND({1\2\3\4\5\6\7\8\9\0};A1&1234567890))=4);1;NA())
    copied down
    once the above is in place:

    -- Highlight column B -> F5 -> Special -> Formulas: uncheck all but Errors -> OK
    -- via Home Tab on Ribbon -> Delete Sheet Rows
    -- finally delete column B to remove legacy formulae.
    Last edited by DonkeyOte; 01-02-2010 at 04:16 PM. Reason: changed to Slovak based locale delimiter

+ Reply to Thread

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