+ Reply to Thread
Results 1 to 5 of 5

Double and a Triple Cross Reference Data Dumps

  1. #1
    Registered User
    Join Date
    04-16-2020
    Location
    California, CA
    MS-Off Ver
    2017
    Posts
    12

    Double and a Triple Cross Reference Data Dumps

    So I am trying to create a spreadsheet for work that helps with Our Inventory Management System

    But the Data Dump that the System gives is a Mess to say the least and I need to figure out how to Cross Reference Product, Person and Today's date to get Today's Product only and then subtract that number with Person and Product in order to get the Hold Over.
    Attached Files Attached Files
    Last edited by Eric Barajas; 04-16-2020 at 08:54 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Double and a Triple Cross Reference Data Dumps

    Sorry, I'm not familiar with inventory management systems, so the term "hold over" doesn't mean much to me. However, this put in a cell will give you the sum of all oranges grown by Sally with today's date:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Omit the final (sheet1!$M$2...) to get all oranges grown by Sally in the data table:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Does this help you get started?

    Tim
    Never stop learning!
    <--- please consider *-ing !

  3. #3
    Registered User
    Join Date
    04-16-2020
    Location
    California, CA
    MS-Off Ver
    2017
    Posts
    12

    Re: Double and a Triple Cross Reference Data Dumps

    Holy hell that was fast. This is just what I needed. I over simplified my example and still have to tinker a bit but Iím now in the ballpark where I hope i can figure it out

  4. #4
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Double and a Triple Cross Reference Data Dumps

    Haha! Must've just hit it lucky!

    I see you're relatively new to the forum, so just a gentle reminder to mark the thread as [SOLVED] using the thread tools at the top of the page. You can also leave feedback and show your appreciation for anyone who's helped by hitting the * button to the left of each post.

    Tim

  5. #5
    Registered User
    Join Date
    04-16-2020
    Location
    California, CA
    MS-Off Ver
    2017
    Posts
    12

    Re: Double and a Triple Cross Reference Data Dumps

    Did not forget. Just am still at work. though I might be back later. My tinkering is not working out for me

+ 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] help calculating how many days take a number to double (or triple)
    By nautilia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2020, 02:43 PM
  2. Sorting data dumps
    By freeloaderdono in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2019, 08:21 PM
  3. [SOLVED] to detect double and triple strings last digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2019, 03:09 PM
  4. Data Dumps compiler for matching Columns
    By iamarush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2017, 03:03 AM
  5. [SOLVED] Cross reference with multiple instances in reference data
    By Nick F in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2013, 10:31 AM
  6. Text Data Manipulation from different dumps
    By thorrrr in forum Excel General
    Replies: 12
    Last Post: 01-14-2012, 02:17 PM
  7. Replace 'Double or Triple Spaces
    By hardeep.kanwar in forum Word Formatting & General
    Replies: 2
    Last Post: 07-19-2010, 02:30 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