contract

Good day, Please assist, I would like to lookup a value for a certain date. Below is a sample of my data. The one sheet will have the contract data e.g. Machine no, date, contract data (is machine in contract for the specific month) <tbody> Machine No Date Contract 123567 01.01.2018 Yes...

I have a listing of multiple contracts with the date (mm/dd/yy) each time a delivery was made and I need to find the sum of how many deliveries were made each year for each contract. I'm assuming I'd need to use a sumifs or sumproduct but not sure how to do so. Contracts are in range A2:A3390...

Hello, I hope someone can help me. Every week a person is working hours. Sometimes more and sometimes less than the contract hours (on a weekly base). I want to count them if they are higher than the weekly contract hours, but go back to 0 if there is a week lower than contract hours (and...

Hi, I am new to this forum and this is my 1st post for help. I have outlined the problem below: <tbody> A B C D E F G H I J K 1 Job number visit date Job type Status 1st 2nd 3rd 4th 5th 2 23502-3 04/04/2017 Contract Visit completed 1 2 3 4 5 3 23502-4...

Got two sets of data that I want to compare against each other. Here's what the data sets look like - <tbody> Contract # Supplier Approved? Service LookupKey 1 ABC Company Yes Trash Removal 1;Trash Removal 1 ABC Company Yes Landscaping 1; Landscaping 2 Bobs Company No Landscaping 3...

Hi Again, I have another formula giving me trouble ... (LOL) =IF(B13="FT",(F18/37.5*C20),IF(B13="contract",(F18/37.5*C20),IF(B13="PT",52.5))) The formula works as is BUT I want it to do this instead: If B13=FT (F18/37.5*20) if B13 = PT enter 52.5 If B13 = Contract AND D13 = PT then enter...

Hi, I have an ongoing project where I fill in cells of scheduled work times for staff that results in displaying their start and finish times, sometimes over 7 hours and always 8 hours or more this will include a scheduled unpaid break so this time needs to be deducted. My current formula does...

Hello everybody :), I got a little excel task to do, however I really cannot get my head around how to solve it, so I hope you guys can help me out. The problem: I have a list of contracts with contract IDs in column A. However, not all of the contracts are completely different ones. Some of...

Is there an easy (non array) formula that will return only 437399? BOOK / YEAR : FRC/16: Contract Number : 437399 My current formula is =IF(ISNA(VLOOKUP(E18,Table_Query_from_Dmaster,4,FALSE)),"NIS",VLOOKUP(E18,Table_Query_from_Dmaster,4,FALSE)) Thanks

Hey everyone, I'm trying to perform data analysis and need to pull in a contract number based on an ID field and determine which record to pull for that ID based on where the Prod Date falls within the From/To Date Ranges (which are each a different column). My data has a unique record per ID...

How could I rearrange the columns by the columns header name. I need to process a report on weekly basis,the raw worksheet has 23 columns.I abstract a part of them as example. Raw columns sequence： <tbody> QTY Payment Terms Contract No. </tbody> Desired columns sequence...

I'm having trouble with a counting formula. We have a table setup that logs bids on jobs. Column A is a job number, Column B is Job Name Column C is Status of Bid (Data Validation with either: Quote, Job, Change Order, Complete, Lost) Column D is Date of Bid Column E is Contract Value I want...

Hello, I have a database that tracks a list of contracts on one tab and contract modifications on another tab. Both tabs have different columns, but also have some matching column names. What I'm trying to accomplish is to consolidate the information into one tab. For every "Contract ID"...

Hi folks, I run a medium/large IT company and we currently have open negotiations with 35 different organisations. We are currently using a combination of Excel and Mail for Mac to manage and keep track of these numerous contract negotiations. Excel: a table listing company, country...

I have a spreadsheet setup as follows: Column A is a contract Amount (Example $100) Column B is a Date (Month-Year as Sep-17) that represents the contracts start date Column C is a Date (Month-Year as Sep-17) that represents the contracts end date Column D through infinity is months of the...

I wish to highlight cells on specific dates on monthly basis. I have tried many ways but am unable to get it work, requesting for help. Highly appreciate. example : # | Name | From | To | Due every Contract 1 | Abc Co | 15 May 2016 | 14 May 2017...

Hi I am looking to write a macro where it takes the information from the 1st sheet and copies it out to the appropriate worksheets when I run the macro. I am looking to move them out into worksheets named after contract numbers 8060, 8290, 8483 as examples. There will be a column in the front...

We have contracts that have multiple projects. Each project stands alone for payment but all projects must be completed before the contract is considered complete. I'm making a pivot table and pivot chart. My boss wants to see projects that are 95% or more complete. I added a formula...

Hi All I have 2 columns of data, J3:J93 with contract numbers and I3:I93 with amounts. I've got as far as using the following sumproduct function for column O3:O93, which works OK but ends up with duplicates all over the place because I have it on each row. For example, column J may have 90...

I've been working on this for hours and haven't been able to figure it out. I'm hoping one of you smart people can help. I created a spreadsheet to help me calculate costs of some of our long term contracts. There is one part of this spreadsheet that is causing me more grief than I thought...