+ Reply to Thread
Results 1 to 3 of 3

Input result if a criteria is not matched from range

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    65

    Input result if a criteria is not matched from range

    I got a formula, but realize that it can only be done via macro...

    What I want to do is to look from Range F2:ZZ (until no more data), if it is different than "001-", then it will delete that cell + the cell next to it and input Invalid thereafter on the next column. Something is wrong with my code. Expertise are welcome.

    Thanks for the help.

    Here is my code (not working):
    Please Login or Register  to view this content.
    Here is what I want as result:
    range.png

    Report.xlsm

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Input result if a criteria is not matched from range

    maybe so
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,044

    Re: Input result if a criteria is not matched from range

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-13-2015, 07:27 PM
  2. [SOLVED] Serach a range of criteria to ge tthe result
    By Beach Walker in forum Excel General
    Replies: 11
    Last Post: 07-08-2014, 04:45 AM
  3. Countif using VBA to define range, criteria and result cell
    By mantili in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2013, 02:19 PM
  4. [SOLVED] help: i need to input date range & 1 criteria then sumup
    By go14344 in forum Excel General
    Replies: 2
    Last Post: 05-22-2012, 02:34 AM
  5. Macro to loop through all worksheets, pulling a range of cells if criteria matched.
    By strictlydiesel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 12:37 AM
  6. How to input a sub result into a range
    By rockyire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2007, 12:35 PM
  7. ISNA vlookup return matched result
    By shovelnose in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2005, 08:20 AM

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