+ Reply to Thread
Results 1 to 2 of 2

Formula to check if set is complete & missing item.

  1. #1
    Forum Contributor
    Join Date
    08-27-2015
    Location
    Singapore
    MS-Off Ver
    Office 2010, Office 365
    Posts
    158

    Formula to check if set is complete & missing item.

    Hi All.
    I need to generate a result as per attached. Details for the file is as below.

    1. Sheet 1 tab is a fixed sheet of data. Over time there might be more set and more food to add in. But the qty inside is fixed.
    2. Daily tab is a sheet where there will be constant changes in the data everyday but the food and which set it belongs to will be accurately.
    3. I need a result that will tell me in Daily sheet which are the set that are complete and which set with missing food.
    4. By typing the set #, I would like the result from item 3. (I don't need the result to be in sentence just show which food will do).
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Formula to check if set is complete & missing item.

    Here is a not so elegant solution involving multiple helper ranges and a UDF.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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] Repeat rows to complete missing numbers in a series
    By jenmc84 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-22-2015, 05:57 AM
  2. Formula with Macro not pasted complete, ' missing
    By Dubrock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 07:57 AM
  3. Consolidating missing data across multiple rows into one complete row
    By pilboroughv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-19-2014, 07:05 AM
  4. Complete Missing Row Data based on Row above
    By SamLN in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-22-2014, 04:54 AM
  5. Macros/Finding missing and complete addresses
    By tutv088 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 12:27 PM
  6. [SOLVED] Vb code To Find the missing triplets and complete the number series..?
    By sem in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 05-31-2012, 02:48 PM
  7. Find and complete missing times in a huge list
    By Jessica.Bush in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-05-2011, 08:34 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