+ Reply to Thread
Results 1 to 5 of 5

Formula to skip cell if condition is true/false

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    Boston, Massachusetts
    MS-Off Ver
    Windows 10
    Posts
    3

    Formula to skip cell if condition is true/false

    I am trying to auto-generate the table shown in the attached Column E so that it dynamically updates if the data in Columns A, B, and C change. The goal is to skip duplicate values in Column B without having any blank rows generated in Column E. This is just a simple example but I would apply this formula to more complex worksheets if anyone has an answer. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Formula to skip cell if condition is true/false

    Try this in E2:

    =IFERROR(INDEX(B$2:B$15,MATCH(0,COUNTIF(E$1:E1,B$2:B$15),0)),"") Ctrl Shift Enter

  3. #3
    Registered User
    Join Date
    11-08-2017
    Location
    Boston, Massachusetts
    MS-Off Ver
    Windows 10
    Posts
    3

    Re: Formula to skip cell if condition is true/false

    It worked! Thank you!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Formula to skip cell if condition is true/false

    You can put this formula in D2:

    =IF(B2="","",IF(COUNTIF(B$2:B2,B2)=1,MAX(D$1:D1)+1,""))

    and copy it down to the bottom of your table. You could set the font colour to white in this column if you don't want to see the numbers that the formula generates.

    Then you can use this formula in E2:

    =IFERROR(INDEX(B:B,MATCH(ROWS($1:1),D:D,0)),"")

    and again, copy this down to the bottom of your table. If you then add a new Type on row 10 or below, then it will appear in column E automatically, but if the new entry is a duplicate then it won't show.

    Hope this helps.

    Pete

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Formula to skip cell if condition is true/false

    You're welcome. Thanks for the rep!
    Last edited by 63falcondude; 12-13-2018 at 02:47 PM. Reason: Rep Added

+ 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. [SOLVED] Formula to skip row if false condition
    By thenormanizer in forum Excel General
    Replies: 2
    Last Post: 12-13-2017, 01:59 AM
  2. [SOLVED] IF FALSE, SKIP TO NEXT TRUE ROW - Need formula, not filters
    By rwernlund in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2015, 04:54 PM
  3. [SOLVED] Skip "False" in IF and continue numbering in cell until True match, then move down cell
    By simonfinnerty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2015, 06:06 PM
  4. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  5. If True/False Condition
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-04-2012, 05:18 PM
  6. Condition code True False on Checkbox
    By RobertCo in forum Excel General
    Replies: 2
    Last Post: 12-16-2006, 07:47 AM
  7. Replies: 3
    Last Post: 03-06-2005, 12:00 PM

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