term

I would like to do the following: Enter a search term into cell A1 Compare this search term with a lookup table (in range D1:D100) If the text is found then it should return the word 'correct' in cell B1 and copy and paste the search term into a new range starting in cell A5 The text in cell A1...

Hi All I am trying to make a search button that when clicked it will find the search term in a specific column and then save the row number in a cell. I have managed to work this out but it can only find the first instance. I would like it the button can find the next instance of the search...

Hi, Is it possible to code something that does the following in the current sheet (Sheet1). (I have 2 tabs which are Sheet1, AA) 1. If cell value in F1 of "AA" tab = 1 then in Sheet1 find the term ABC and delete the entire row that contains this ABC term 2. If cell value in F1 of "AA" tab =...

Hi Guys, I hope you’ll be able to assist me with the below code. I’m trying to build 4 d active dependent Combo Boxes. I got great assistance from one of the forum members here. However, I’m afraid the code works perfectly till “Case 3000”, starting from this case, it doesn’t work...

Excel 2013 Windows 7 64 Good Afternoon. I'm trying to use an Icon set of the Green, Yellow, Red type that returns a Green "check mark" if the row A1:F1 containers no errors. Something like the below. The values in "Term QTY" and "Term Size" are populated by an Index/Match formula based on...

I just watched a video on how to user MS Query. I do not see the difference between power query and ms query in term of functionality. Then why we have both? Thank you.

Hi I have a combobox with 2 columns - 1st column is bound, when I begin to enter a term it jumps to the right place in the list (sorted alphabetically) if i select a term from the list all's ok.The problem is when I try and to exit the combobox or enter a term that's not on the list I get the...

Hey Guys, I have a term sheet template in the form of a word document, as well as an excel worksheet that contains all the information necessary to fill out the term sheet. I created a bookmark for each range I needed to fill out in the word document, and I also named each range in excel by the...

Hi, I've come for some (hopefully) quick macro help. I have a spreadsheet where I need to Combine columns A and C with the operator in column B to give the expected results below. For each search term in column A, it needs to be run with every search term in column B separately. For example...

I have 2 columns, 1 has a term, the other sub-terms related to the term. Let's call Col A the 'main' category, and Col B the 'sub' category. What I want to do is merge Main with sub so that the Main category and the sub category appear together in the same cell (Col C). Problem: <table>...

Hi all, I have a form that before updating, I want to store the old value of one particular field. The original field is an integer, and I want to store the text description. My code looks like this: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim FormName As String Dim OldBusinessterm...

Criteria for the query include: Transaction ID, Loan ID, First Name, Last Name, State, Loan Date, Loan Purpose, Loan Amount, Loan Term, Interest Rate, Loan Type, Loan Age(months), Loan Use, New Interest Rate, and Loan Maturity Date. Query Question: What percent of all loans are of amount at...

I need help with a formula in Excel to work out the annual percentage to increase payments for a loan. So if a loan of £2,000,000 is given, the loan payment term is 15 years and the interest rate is 12%. The PMT would be £24,003.36 per month. But what I need to do is allow the lender to pay...

This problem has been plaguing my team for months and its about time I asked the pros. Within a larger formula, I have an OFFSET term within a larger "IF" construct that evaluates to two different answers: OFFSET('OTHER_Sheet'!$D53,-MOD(MROUND(YEARFRAC($F60,J$4,0),1/12)*12,M$6+M$7)+M$7,J$2)...

Hi everyone, I wanted to check if someone knows a way of simplifying a data cleaning process I do often. Suppose below is the data I have to clean: <tbody> A B C 1 Data To Clean Term to Search Term To Replace with 2 Essential Blue Blue Blue 3 Deep Purple Purple Purple 4 Bright Yellow...

I have a worksheet that will be used to forecast annual costs for contracts of various term lengths. In my cell C9 I enter in the number of months in the contract term (i.e., 24). This number is variable depending on the term length of the contract. I'd like a formula I can use put in C39...

I have this line of code ... .Range("D1").Formula = "=if(C1="""",0,if(C1=""OFF*"",0, if(c1=""STAT"",7.5,(C1-B1)*24-0.5)))" If worked fine when I was simply comparing for the term "OFF", but I have since needed to adapt it for anything beginning with "OFF". I assume a wildcard '*' will not...

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

Using chart functions or some other display mode in Excel, I want to be able to compare contracts based on start / end dates to show overlaps or gaps in time or coverage. The user inputs dates on a spreadsheet and the chart is created to show them if the contract coverage is correct or has gaps...

Hey guys. I'm new to the Mr Excel message board, I just came out because I had a question that interested me. Sequences. Those lovely little chains going up by a certain number, like 1, 2, 3, 4 ... or 2, 4, 6, 8 ... or 5, 3, 1, -1 ... they have a common term that dictates the sequence. For...