Results 1 to 5 of 5

Skip, ignore or miss false value

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2020
    Location
    Murcia, Spain
    MS-Off Ver
    2013
    Posts
    6

    Skip, ignore or miss false value

    I am looking to copy data from one cell to another, only if something is true. If it is false I want it to ignore the false side of things and not leave a blank cell, or put a zero or false. Just to leave the cell as is (as the cell will have data in already that I don't want overwritten.

    Please see the attached file.
    If any false HAS to be written, could it then write the false output to the blank cell to the right of it?

    (Apologies if this has been answered before, I've searched and searched and couldn't find just what I was after, or adjust previous similar results to work for this scenario)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If statement is false, skip to next row
    By tbraden in forum Excel General
    Replies: 3
    Last Post: 12-18-2018, 10:34 AM
  2. IF function (IF False skip to next row)
    By FatmaMS in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-13-2016, 09:29 AM
  3. [SOLVED] IF FALSE, skip to the next row
    By MYazal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2016, 06:28 PM
  4. [SOLVED] False value, then skip to next line, etc.
    By hidden78731 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-24-2016, 03:10 PM
  5. VBA ignore or skip worksheets if not available
    By sk88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 04:15 PM
  6. [SOLVED] How do I Skip a Row if the Value is False
    By coconnor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2012, 10:26 AM
  7. [SOLVED] If false skip to next
    By irresistible007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2005, 07:10 AM

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