Results 1 to 18 of 18

Select each row one by one and check for a substring in each cell of it

Threaded View

  1. #3
    Registered User
    Join Date
    04-27-2012
    Location
    New Delhi
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Select each row one by one and check for a substring in each cell of it

    Please find the file. I want to check from the column Age, Comments and Summary and the follow the above mentioed proceedure. I would need the rows with Name A, g, q to be removed (as they contain the required substring) from the sheet. (Sorry Iam not able to attach the file, facing some problem)

    Name Reg. Date Age Comments Summary
    A 22-04-2012 1 alkdfhklashf lkgjlkj good morningladsjflkj
    b 22-04-2012 2 qewrthdkj xkcnj,xzn
    c 22-04-2012 3 gkjqhkrtghkgv vkhakh
    d 22-04-2012 4 dskbvakjdhv cxbv
    e 22-04-2012 5 dslfhekrhg ewru
    f 22-04-2012 6 dvnbcxmvh xzjcb
    g 22-04-2012 7 lkdgalsjgood morningadlfjas aieur
    h 22-04-2012 8 aldshgfkladh zxc,mnx
    i 22-04-2012 9 adterig rietuire
    j 22-04-2012 34 dlktjeri dfgghcvxc
    k 22-04-2012 23 cxvn,mn xcbcvn
    l 22-04-2012 12 eritue dfgdfh
    m 22-04-2012 76 cxbv sdfsdf
    n 22-04-2012 87 aeiwtu xcvbcvbn
    o 22-04-2012 53 adncb sfsfgdh
    p 22-04-2012 33 akeur xcvbcvbn
    q 22-04-2012 54 dmnfv,good morningadlkfjaklj sddfd
    r 22-04-2012 24 dlkfn zxvzv
    s 22-04-2012 65 arot dfhdfh
    t 22-04-2012 43 damvn cxvdfghdf
    Last edited by Abhushan86; 04-27-2012 at 12:59 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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