Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-15-2018, 11:57 PM
Ninphysics Ninphysics is offline Windows 10 Office 2013
Novice
 
Join Date: May 2018
Posts: 1
Ninphysics is on a distinguished road
Question I am trying to cross reference data, and I need the right formula.


I have been tasked with completing a report that compares scheduled departure times of the outgoing loads from my facility with the actual departure times of those loads. I have been doing this manually as each load departs, but I have been trying to find a way to automate the entire process so that I can pull the data at the end of the day and get the report immediately. I have been running into issues with this and would appreciate any help or input. The issue I'm running into is that the schedule is wildly inaccurate at times and the destinations are reoccurring. My company wants to ensure that even if there are extra loads generated for a certain destination that we still meet the last scheduled time for that specific destination. Having this specification has made it difficult to return the results I desire. If this is doable then I think I'm on the right track, I'm just missing a formula or two. I have attached a spreadsheet that shows the steps I have made so far and how close I am to my desired results. I am a VERY inexperienced excel user so please be kind. In fact I have not used excel since I took a class to learn the basics back in high school! I would very much appreciate any help regarding this issue. Thanks in Advance.
Attached Files
File Type: xlsx example.xlsx (14.6 KB, 5 views)

Last edited by Pecoflyer; 05-16-2018 at 12:08 AM. Reason: Removed unnecessary part of title
Reply With Quote
  #2  
Old 05-16-2018, 02:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 275
ArviLaanemets is on a distinguished road
Default

I could not desipher, what you exactly wanted, so I made 2 possible solutions. On sheet Shedule, columns for Rep1 take loads sent actually out as base, and are matching them with scheduled loads. Colums for Rep2 take scheduled loads as base, and are matching them with actual loads.

In either of reports, something is left out. To get a report, where all scheduled loads and all actual loads are displayed, and positioned to match, can't be made in same table, and is much more complex to create.

Btw, in my solution the actual position of loads in table is moot - the load numbers are calculated based on scheduled/actual time.
Attached Files
File Type: xlsx example2.xlsx (23.2 KB, 9 views)
Reply With Quote
Reply

Tags
cross referencing, formula help, index match

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross reference data from 2 different worksheets connell.richard@gmail.com Excel 0 12-06-2016 04:26 AM
Cross-reference / lookup data from one tab and display on another - How to lonniepoet Excel 0 02-24-2016 01:31 PM
Formulas/Scripts That Cross Reference & Import Data ekeithjohnson Excel Programming 3 08-23-2014 11:26 PM
Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
Cross-reference together with Mathtype formula is not working correct Santa_Clause Word 2 02-02-2010 04:37 AM


All times are GMT -7. The time now is 09:57 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft