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. #1
    Registered User
    Join Date
    04-27-2012
    Location
    New Delhi
    MS-Off Ver
    Excel 2010
    Posts
    31

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

    Hello,

    I wanted to check for a substring (say "Good morning") in every cell of each row starting from a particular column (say C till E) one by one and, at the first instance of finding that substring in any cell it should remove that row completely and proceed to the next row and repeat the same thing till all the rows are exhausted.

    I hope I did not confuse it.
    Thank you for the help.
    Last edited by Abhushan86; 04-27-2012 at 12:38 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