+ Reply to Thread
Results 1 to 4 of 4

Narrowing down value list based on values in adjacent column

  1. #1
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Narrowing down value list based on values in adjacent column

    Hi all,

    Have a list of SKU's that I am trying to narrow down.

    Column A has the sku's I would like to narrow down, column F has all the sku's in column A plus more.. Column G has the quantities of the sku in column F.

    So for Column A, I would weed down what SKU has a zero quantity (or blank), column B should show all SKU that has a value of 1 or greater.

    Please see attached.
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,373

    Re: Narrowing down value list based on values in adjacent column

    perhaps something like this?
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Re: Narrowing down value list based on values in adjacent column

    Yes, but I think it is returning values (SKU's) that are not in column A

    If the SKU is not in column A, then I can't have it in column B.

    Only trying to find what SKU (column A) have a quantity greater than 0, these values are in column F and G.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,700

    Re: Narrowing down value list based on values in adjacent column

    Try pasting the following formula in B2, then double click to copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Create Unique List based on matching value in adjacent column
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2016, 01:29 PM
  2. Replies: 3
    Last Post: 11-13-2015, 05:10 AM
  3. Sum up a column based off adjacent column and replace values with the sum.
    By kleptilian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2015, 11:55 AM
  4. Replies: 19
    Last Post: 04-17-2013, 09:51 PM
  5. Replies: 3
    Last Post: 03-21-2013, 09:28 AM
  6. [SOLVED] Summing values in one column based on their adjacent values
    By undoubtedlymegz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2013, 04:57 PM
  7. Replies: 1
    Last Post: 03-02-2013, 05:06 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