+ Reply to Thread
Results 1 to 4 of 4

array formula or formula to return column data except for certain data.

  1. #1
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    array formula or formula to return column data except for certain data.

    Hi,

    I have a list of 20 vehicle parts in a column A and I also have a list of 5 of the parts listed in column A in column B. Is there a formula that can return all the parts in column A except for those listed in column B?
    So basically the list in column B can be found in column A but I only want the formula to return a the list in column A but the formula results should not return any of the list in column B.

    Your help is much appreciated.

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

    Re: array formula or formula to return column data except for certain data.

    See attached file - is that what you are looking for?

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-17-2013
    Location
    USA, IL
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: array formula or formula to return column data except for certain data.

    Thank you Pete_UK, this is exactly the assistance I requested for.

    Very much appreciated Sir.

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

    Re: array formula or formula to return column data except for certain data.

    You're welcome - thanks for the rep.

    Pete

+ 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] How to return column title from an array formula
    By nappy1001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2018, 10:55 AM
  2. Replies: 31
    Last Post: 11-09-2016, 05:00 AM
  3. [SOLVED] part of array formula based on data change in another column?
    By njs27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-29-2016, 02:25 PM
  4. Formula to return column reference of data looked up from another worksheet
    By pixifaery in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2015, 05:38 AM
  5. [SOLVED] Formula to return score of 0-100 based on column of number data?
    By theronager in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-22-2013, 06:45 PM
  6. [SOLVED] I need a formula to return a column of data from sheet1 into sheet 2
    By DustOfTheEarth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 06:36 PM
  7. formula to return data from previous column
    By mheinmiller in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2008, 10:26 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