+ Reply to Thread
Results 1 to 6 of 6

How make Excel automatically choose from a list off missing items

  1. #1
    Registered User
    Join Date
    08-17-2020
    Location
    Newquay, England
    MS-Off Ver
    16.21
    Posts
    3

    How make Excel automatically choose from a list off missing items

    Hi all! From someone not at all tech savvy (and with very basic excel knowledge): I have a list of designs of which my customers being sent one every month. I have a list of items a customer already has. I would like to generate an automatic choice of next design to be sent based on what they don't have yet AND prioritise amongst available choices. Is this possible in excel?
    I would like the highlighted column to be automated.

    Many thanks for any help in advance
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: How make Excel automatically choose from a list off missing items

    Is it the coincidence of priority between priority list and B2:K2? if no, try:

    L3:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: How make Excel automatically choose from a list off missing items

    With B2:K2 is NOT in prioty order,

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-17-2020
    Location
    Newquay, England
    MS-Off Ver
    16.21
    Posts
    3

    Re: How make Excel automatically choose from a list off missing items

    To me it worked with the first, more simple formula - but obviously, I believe you, I am just curious why wouldn't it be right?

  5. #5
    Registered User
    Join Date
    08-17-2020
    Location
    Newquay, England
    MS-Off Ver
    16.21
    Posts
    3

    Re: How make Excel automatically choose from a list off missing items

    I am at a different stage now and wanted to know if it is possible to extend this formula to have a second and a third choice of the priority list generated in additional columns (have a second and a third best option listed as well).

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: How make Excel automatically choose from a list off missing items

    From column M to the right is second, third,... until end

    In M3:

    Please Login or Register  to view this content.
    Drag down and accross

    Assuming that column B:K are sorted by priority. Priority list in B12:B21 now is not participarted.
    Attached Files Attached Files

+ 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. How to compare to a list and return missing list items in summary. (if/and)
    By bigtunelover in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-07-2020, 02:06 AM
  2. Macro to filter list of missing items.
    By fullmetalchrono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2020, 08:58 PM
  3. Formula for checking what items are missing from a list
    By tukae in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2019, 12:09 AM
  4. Choose dropdown list than automatically show formula?
    By Mr.Castle in forum Excel General
    Replies: 6
    Last Post: 04-10-2019, 10:18 AM
  5. [SOLVED] Make a List of All visible Pivot items in Excel
    By dinesh_ltjd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2014, 03:11 PM
  6. Can I make a drop down list to choose formats not values?
    By AhmedIsmail759 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 04:35 AM
  7. Userform Combobox - Choose Multiple Items from list and input on seperate lines
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2012, 04:09 PM

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