contract

Hi I have a list of contracts that includes their end date and their annual value, e.g. A1 = name of contract B1 = 31/12/2018 (end date) C1 = 500,000 (contract value) I want a formula to count how many dates in column B fall within a particular month and another formula to sum the...

Hello Friends, Vlookup formula is not giving the desired results when some cells in the range are merged. For Example. A B PO # Contract # 2) 301675 3) 301684 21130697 4) 301687 Column B2:B4 are merged cells =vlookup(c1,a2:b4,2,0) Now when i enter the po...

Hi all, I'm hoping someone could help me with a formula or perhaps a VLOOKUP. I've been trying different things and can't seem to get where I need to be. What I have is Sheet A with Contacts. Each Contact is associated with a Service Contract on Sheet A. On a second Sheet B, I have a list...

Hi, I have a data set of about 500 lines In Column B I have contract codes In Column C I have account numbers In Column T I have total costs For each Contract, I need to extract the 10 largest accounts value and return the account number to another sheet. If it was just one contract and no...

A B C D E F G <colgroup><col span="3"><col><col><col><col></colgroup><tbody> PAIR PRICE1 PRICE2 PIP VARIANCE PERCENTAGE CHANGE CONTRACT SIZE P/L AUD/USD 0.7155 0.72 0.0045 0.62% 20000 $90...

I'm struggling with what I thought would be a simple formula. In column E of a spreadsheet, I have a the years contracts begin. In column G, I have the number of years the contract will last and column I has the annual payment amount. On a second spreadsheet, I have 5 years in columns G thru...

I have a report that should calculate won sales of reps in our company based on the date the contract was processed is where the contract totals should appear in the report for the entire calendar year 2018. Based on my data for a particular rep, the total amount is supposed to be $14,765...

Hello, I am trying to get C9 to balance out as $347,530.30. Can you help with this please? Please see image attached for details. <colgroup><col width="304" style="width: 228pt; mso-width-source: userset; mso-width-alt: 11117;"> <col width="154" style="width: 116pt; mso-width-source...

Not sure how or if this can be done. Workload pull has in column "A" contract number, (hundreds of contract numbers), column "B" has the line item for each contract number, column "C" purchase qty, column "D" shipped qty, column "E" accepted qty. Need a formulas in column "F" to identify...

Bonjour, I have a spreadsheet at the moment for pricing up jobs for different contracts. Each contract has its own mark up. I was wondering if there was a formula I could put into 1 cell (and then used for the rest of the column) so it could simplify the process. For example, if A1 contains...

Hello I am needing some help or ideas of how to easily transform original data into a simplified list, ideally just a pivot, but because my original data has tons of columns and due to the circumstances.. I am giving up hope that there is not an easier way to do this.. Background: 1. It is...

Background information: I work with lots of products that require contracts where the contracts are largely similar but may have different fields have and different language required. I'm trying to automate this entire process where I have a main "Inputs" Page and based on what I check and fill...

Hi, i am quite new to the excel world and i was asked to help our field service team. basically I try to make a kind of a cheat sheet - to let our team understand what they should mark and what they should not mark. I need to check two fields. Named as "Work" and the second is "Billing" each...

Hello, I have three columns, Department, Employee Name, and Contract Status. The data table is about 670 rows and will continue to grow. Thus, on a separate tab, I would like to extract the Department and Employee Name columns, but the rules are as follows: 1) Sort alphabetically...

hi All, I have the below formula that returns the value of £0.00 in words but I want to change the formula to add two cells V4 and V12 together but I cant get it to work. any ideas on how I do this. =IF(P8="Total Contract Sum","£0.00","") Thanks Steve

I am trying to create a macro to copy only cell in 3 columns that have data. I have the macro working in one of the columns but if I try one to the left or all three in a range it doesn't select properly and am unable to proceed. I use this and it works fine. 'Copy Cost Codes and Qty as Text...

Hello...I need some help with date-related formula: I signed a 3-month contract with a client in the amount of $300 effectrive from January 15 to April 15. I would like a formula that returns the revenue each month as follows: January: $50 (pro-rated since the contract started January 15)...

Hello Everyone - Looking for a formula that will calc. the start date of a contract for me given the exact date it was signed based on mid month convention. Examples If a contract is signed in the 1st 15 days of the month, then the contract start date is the 1st of that month. If a contract...

Hi Excel Gurus, I am currently working on a Project that requires me to look up the respective value: Here is how it goes, I have got 2 workbooks, one is the master workbook that contains data such as: Workbook 1 <tbody> Serial Number Contract fee Maintanence fee Contract cost Maintanence...

Hi i have an excel which requires allocating a sum across the months in a contract period. And in case of early termination of contract, the unallocated sum is required to put into the month when the contract is terminated. how can i do the allocation using excel formula? hope someone can...