contract

  1. M

    Challenging If/And statement help please

    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...
  2. S

    Too many arguments in IF function

    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)...
  3. F

    VBA Remove only certain duplicates

    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...
  4. N

    Formula to locate an entry with a date up to 15 days in the future

    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...
  5. C

    Formula HELP!!?

    <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...
  6. D

    Equivalent of DATESBETWEEN(LASTDATE... ?

    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...
  7. J

    Countifs/sumproduct help!!!

    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...
  8. J

    Extensive Excel Formula

    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...
  9. G

    Can Sumifs exclude or minus a range from a list of data while still summing other ranges

    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...
  10. G

    Passing variables from Child (Word) to Parent (Excel)

    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...
  11. T

    DMin function on an Access 2016 form to find lowest value in multiple controls

    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...
  12. I

    Make mandatory depending on other column value

    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...
  13. G

    Passing variables from Child (Word) to Parent (Excel)

    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...
  14. H

    Date Range Lookup Question

    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...
  15. Z

    QUERY ON Sheets("X").Move After:=Workbooks("Y.xlsm").Sheets(1)

    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")...
  16. T

    Rows to Columns (previous thread corrupted?)

    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...
  17. T

    Rows to columns

    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>...
  18. M

    multiple date look up from different rows from two tabs

    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...
  19. S

    Many to Many?

    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...
  20. A

    Excel 2016 - Data Organization Help

    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 -...

Some videos you may like

This Week's Hot Topics

Top