Results 1 to 4 of 4

If false, ignore and skip to next row

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2020
    Location
    Bristol, UK
    MS-Off Ver
    365
    Posts
    2

    If false, ignore and skip to next row

    I have a large table of data and I need to create sub-tables that have the same columns, but a subset of the data based upon whether a certain value appears in the first column.

    In the supplied workbook I have created some sample data. I would like to create subtables for based on the value in column A.

    E.g. I would like a sub-table with all the rows where the value in column A is '9T'.
    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. [SOLVED] Skip, ignore or miss false value
    By robg76 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2020, 05:15 AM
  2. If statement is false, skip to next row
    By tbraden in forum Excel General
    Replies: 3
    Last Post: 12-18-2018, 10:34 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

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