term

Hello all, I have searched the archives and have found people asking (and answering) similar questions—but none of them quite fit my situation. I will attempt to describe it as clearly as I can. I have huge terminology bases containing many translations of many terms, in many languages. No...

Hi, I have a workbook that lists all terms attended for each student as well as their GPA for that term in descending order. What I am trying to achieve is target the top entry for each student, which will give me the last term attended as well as their last known GPA. Please see a short example...

Good Afternoon, I have a vba problem I just can't wrap my head around and I'd appreciate any help. I've thought about using index/match, vlookup, or find, but I just get confused the more I think about it. The ultimate goal is to have a user double click a term which opens a userform and they...

hi all. i'm trying to work a reverse calculation on a finance repayment calculator. i have have the standard amortisation calcs.. $20k amount 84 months 10% interest $332 repayments per month Total interest component of $7890 If i bump the repayments up to $375 per month, it lowers the loan...

Hello, I am currently using the below code to return the worksheet location of over 11,000 part numbers in a spreadsheet with 45 worksheets. Sub test() Dim a, i As Long, ws As Worksheet, r As Range With Sheets("Location_Summary").Cells(1).CurrentRegion .Columns(3).Offset(1).ClearContents a =...

The following code Inserts a blank row after a specific term Sub insertRow() Do If InStr(1, Selection.Value, "Research director:") > 0 Then Selection.Offset(1, 0).Select Selection.EntireRow.Insert End If Selection.Offset(1, 0).Select Loop While Selection.Value<> "" End...

Hi, {=INDEX(K243:K274,MATCH(O245&P245,G243:G274&H243:H274))} Tried to insert an image but it's not working.. please see below for screenshots.. https://imgur.com/a/CUyDEm0 https://imgur.com/5TOZpLs The table on the left.. has 4 components, portfolio, risk, term (from and to) and value. The...

I'm not an Excel expert and my HelpDesk hasn't been able to figure it out either so I searched for experts, and this forum came up! Here is my issue: I'm trying to solve for the cell "????" below. The 2 cells above it are entered so I'm trying to find the July 2018 row that has the date...

Hi I want to Copy & Paste the following headers starting with the first date field (new column H) with macros. <tbody> DoB DoH Entry Date Term Date Disable Date Death Date Officer Staus Cd Own% YTD OverrideHrs SrceLev Elig OptCd Div Term Rehire </tbody> can anyone help me with that

Hello, I am trying to create an aging table for receivables. I have a report that gives me all the detail of what is outstanding but I want to convert the data into 5 buckets. The report gives me the name of the individual, amount, and what term it was from. <tbody> Name Balance Term...

I am hoping someone can help me as I am losing the will to live. I am using conditional formatting to determine whether a gap has gone up or down from the previous term. It is mostly working but for some reason on a few of the data cells the wrong colour is given. I am using the formula...

I am building a cash flow model. Standard income and expenses. the model has months 1-60. I need the expenses to me put in by range. for example taxes will be in month 13 to 33 and insurance will be in months 19 - 44. I am looking for a formula that will look up the ranges and return data in the...

I have an employees start date in cell H11 and the term date in cell I11. In cells J6:U6, I have the months of 1/1/2019 - 12/1/2019. In cells J3:U3, I'm trying to calculate the number of working days that employee worked that month given their starting and term date. If the employee is...

Hello, I thought I was done with my school application project,until I was challenged with another task. In the application there is a report card that shows the first term,second term and third term report when you click "Open Report Card" in the form "frmStudent" a dialog form pops up to...

Hi, I've a bunch of school term dates, and each school has their own method of stating what is the first day or last day of the month (some will say the day before is the first day, some will say the day after, some will say the last week day, etc) & to allow me to better compare i want to be...

<tbody> A (Original Hire) B (Re-Hire) C =IF(A=B, TRUE) D TERM DATE E 1 yr of return F =IF(AND(C1=FALSE,$B1>$D1,$B1<$E1),"Include in Ceremony","Do not Include") 12/8/10 09/25/18 FALSE 2/22/18 2/22/19 Include in ceremony 01/16/17 01/16/17 TRUE </tbody> Hi, this is a...

Hi I have a strange problem with one workbook. When you do anything that requires a recalculation of the sheet the graphics are distorted so that sections of other sheets appear overlaid with the current sheet. Clicking on different tab then returning is a short term fix but I'm keen t know of...

Overview of what i am trying to achieve - I have a list of data that could be 1000 rows long and i want to send an email to everyone manager on the list as a reminder to do something but if a manager appears on the list more than once this means they have multiple employees with the same issue...

Hello - First of all thanks for taking the time to read this post.. I am trying to do a Vlookup for example look at Col Eng which has a 3- then look at Baseline find the 3- in the list and output what is in the next columns, the out put I am looking for is 1= (and the rest of that line)....3-...

Hello I have a formula that looks at the contents of cell G4 anduses the data to reference a specified column in another workbook: =INDEX('[workbook]worksheet'!$H$1:$H$65536,MATCH($G$4,'[workbook]worksheet'!$O$1:$O$65536,)) This works fine as long as the data in G4 is a number. Ifthe cell...