contract

Good day! I hope someone can assist me with the following problem I am trying to get a return value of Yes/No indicating if the customer is active for the current month based on the following (which are all dates) Example 1 Contract Start Date: 01/01/2014 Contract End Date: *blank* Current...

It is saying there are too many arguements, where should I add AND OR in order for this formula to work? =IF($D$1="","",VLOOKUP($D$1,'[Employment Contract (Causual Employee) HC_May20180903_D_SB.xlsx]Staff info summary'!$B:$DQ,91,FALSE)="","",'[Employment Contract (Causual Employee)...

I have a spreadsheet with data in columns A thru F. In column A are contract #'s and in F are percentages. If there are duplicates contract #'s in A, and in column F one of the duplicate contracts is at 100% I need to delete the one that is not 100%. If neither is 100% I need to keep both. Is...

Hi, I am trying to work out a formula which will allow me locate a related entry with a future date (up to +15 days). I have 2 separate lists, one of customers and their contract end dates and a one of customers with renewed contracts and their start dates. I want to look up based on the...

<tbody> remaining Old Contract Credits 10 Price 30 New Contract Credits 50 Price 25 Out of contract (no credits) Price 35 Remaining Credits 60 </tbody> Order <tbody> order 1 number of books order 2 number of books order 3 number of books Book 1 2 2 2 book 2 3 40 0 book...

This query pertains to Power Pivot in Excel 2016. I have a table containing every annual contract, past and present, which includes contract end dates and amounts. (I also have two separate related tables, one for client and one for calendar.) I'm trying to write a measure for a pivot table...

Please see below: Column J and I are the ones where I need help with: * Does the customer have one contract with one service type for the entire year? If so, return SYSR (Single Year Single Rev) * Does the customer have one contract with multiple services for the entire year? If so, return SYMR...

Please see below screenshot. Column J and I are the ones where I need help with. I have tried "countifs" with multiple scenarios, yet cannot get to work exactly how I picture it. * Does the customer have one contract with one service type for the entire year? If so, return SYSR (Single Year...

Hi there, I was just wondering if there is some way of using the sumifs function to minus or subtract a range of data from a large data set? I have a large data set that picks up contract codes in column A and the cost against these in column B. I am looking to exclude certain contract codes...

Hello, I have spent all last week on this and I just can't figure it out. I have an Excel macro which passes some variables to a word sub which works great. What I am then trying to do is pass a Boolean (FileExists) back to Excel but I just have no idea how. I have completely changed loads of...

I am very new to Access and I am trying to figure out of I can use the DMin function to return the lowest value found in several text boxes at once. I am building a simple database for tracking stock and option trades. The tracker form will be filled out manually for scalable entries into...

Hi, In my excel sheet there are 10 columns. If column "E" cell values are equal to "contract" or "permanent", I need to make column "F" and "G" respective raw values are mandatory. Ex: If E5 value is equal to "contract", I should enter "F5" and "G5" values. Highly appreciate , if you can...

Hello, I have spent all day on this and I just can't figure it out. I have an Excel macro which passes some variables to a word sub which works great. What I am then trying to do is pass a Boolean (FileExists) back to Excel but I just have no idea how. I have completely changed loads of bits in...

Hi, I have an Excel file which tracks expiration dates of all items with a support contract. I need to be able to lookup at anytime and quickly identify which items are coming up for renewal in the next 60 days. I can pull the concerned SNs in a separate sheet or color code them in the same...

Hi, Im opening txt files (contract) from a workbook (MC9.xlsm) and moving opened sheet (contract) to the workbook (MC9.xlsm) Windows("CONTRACT").Activate Sheets("CONTRACT").Select Sheets("CONTRACT").Move After:=Workbooks("MC9.xlsm").Sheets(1) Here the workbook name ("MC9.xlsm")...

Good morning everybody, It seems as though my previous attempt didn't post properly somehow (when I click on it there's nothing there at all), so let's try again: I have a table with two key fields and one data field. I need to reorganise it so that the key fields are summarised, with the data...

Good morning everybody I have a large table which I need to reorganise. It has two key fields and one of data, thus: <tbody> Contract Line Charge ID 10914 1 10010016 10914 1 10010932 10914 2 10020624 10915 1 10000883 10915 2 10010703 10915 2 10010244 10915 2 10010243 </tbody>...

I have been trying to figure out how to apply my expected result using a separate tab lookup. The section to the left is what I am trying to populate the expected result from the section on the right. I need to match the agent columns together then plug the tax treatment in the expected result...

All First time on the site so appologies if I can find the answer elsewhere. I have a many to many situation, that I am looking to resolve to give me one dataset. Any advice on formula/ add ins that can be used (cant code in VBA) would be appreicated. Eg Two data sets of <colgroup><col...

I have a report that is generated in an output format that I need to change. I am running a financial detail report for 100 plus properties. The individual properties appear as column headers. The type of spend account appears in Column A. (See below) I need the data to be arranged as such -...