+ Reply to Thread
Results 1 to 2 of 2

Show available items sorted by multiple criteria and without calc error

  1. #1
    Registered User
    Join Date
    08-01-2021
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    21

    Show available items sorted by multiple criteria and without calc error

    Hi Everyone,

    I have a box tracking system and have become stuck on small things.

    I'd like to display a "picklist" of available boxes. The boxes have several stages and can only pop up in the picklist if the previous step has been completed.
    My approach was to use FILTER function (To sort criteria) as well as XLOOKUP on the physical location on of the box (Check in/Out). I'm running a VBA that tended up crashing for some reason using the formulas I'm currently using (I imported the values into the UserForm).

    Fomula for Check In/Out -
    Please Login or Register  to view this content.
    Formula for conditions -
    Please Login or Register  to view this content.
    Attached is the workbook where "BoxIn" tab shows the current status, 'Database' tab shows which box is last in/out (XLOOKUP), and 'Home' tab is where the results are to be displayed.

    Once the list is emtied I'd prefer not to have it show #calc error if possible.

    Hope you magicians can help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    657

    Re: Show available items sorted by multiple criteria and without calc error

    I would add 4 calculated columns on Boxin Tab that use Start in row 2 (Say column K) :
    Please Login or Register  to view this content.
    This should number all of your File Management List. Then on the Home tab - in your File Management Helper starting in Row 3:
    Please Login or Register  to view this content.
    this will bring over the info.
    If this solves your issue, Mark thread as Solved & Add Reputation.

    Thanks!

+ 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. Lookup and show multiple items from list - [SOLVED]
    By Duncan- in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 05-20-2018, 09:47 AM
  2. Count Ifs using multiple criteria sorted by date
    By Jamie_QHSE in forum Excel General
    Replies: 1
    Last Post: 12-18-2017, 09:22 PM
  3. [SOLVED] Multiple Criteria Dependant Drop Down, Less Than Equal To, NOT Sorted
    By carsto in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-29-2016, 01:58 PM
  4. [SOLVED] Formula to show all items that match three criteria
    By Rerock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-17-2014, 01:30 PM
  5. [SOLVED] Formula to show all items that match two criteria?
    By Rerock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-12-2014, 10:35 AM
  6. Replies: 1
    Last Post: 09-04-2014, 12:14 PM
  7. Hide/show specific Pivot Table Items based on multiple criteria
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2009, 05:15 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