initial

Help... I've done something like this before where I had a names entered in to the same cell, but they always had spaces between the first and last or first, middle, last. This time around I'm looking at 15,000 entries where it's a capitalized middle initial immediately followed by the...

I have an issue that only started after an upgrade to Office 365 ProPlus 1708.8431.2215 If I create a PowerQuery using Connection Only, when I reference the connection later via a new pivot table [ Insert ... Pivot Table ... Use an External Data Source ... Choose Connection .... Query A ] then...

=INDEX(Data!$E:$E,MATCH($A2,IF(Data!$H:$H=Summary!E$1,Data!$A:$A),0)) An example of the array formula above would be: Return the Course Title if the Student Name is John Smith and the Department is English. This works for the initial instance. It only works for the initial instance though...

I need to create a function that will allow me to subtract a number P1 from an initial value, followed by this P1 being subtracted from the result RP1 times. Once P1 has been subtracted RP1 times, P2 must be subtracted RP2 times, and then P3 subtracted RP3 times until 0, which it will do as the...

I have a problem where I am looking to calculate the Initial Outlay required to meet a given IRR with 10 periods of the same payments. Desired IRR = 15% Periods= 10 Payments= $219,174.93 Initial Outlay = x Is there a function or formula that will calculate this for me in Excel? Thank you!

I need help solving the following problem. I know what to do with the standard PMT Function but what does one do when one has an initial deposit or down payment. I have to solve the following problem: A client is interested in a certain insurance product. She expects to earn $11, 0000 after 18...

Hi, I wanted to create a yellow pop up window when I click on the rows in a particular table. I have seen this done but can't find the initial code to get me started. Does anyone have the basic structure to use? Thanks

I need to create a field that extracts the first initial from the last name so I can sort members alphabetically by last name. I'm using the Left function which does the trick but I ran into a situation where someone has a maiden name in front of the last name so all the is being returned are...

Hi! I need help building an expression for a field in a query I'm designing. I have columns of dates and types of reviews. Example: SiteID SiteDate Purpose 03500000 05/09/13 Initial Full Scope 03500000 08/17/15 Periodic Full Scope 03500001 05/09/13 Initial Full...

Greetings, I am receiving a loop without Do error at the second "loop". Is it possible to loop to the same initial "Do Until" statement from more than one point? I would like to loop back to the initial point from each GoTo statement. k = Range(Cells(Rows.End(xlUp), b)) Do Until k =...

I have large sheet of names in the format- Last Name, First Name. How can I change this to- First initial of First Name followed by period then Last Name-Thank you.

I have a table such as this one. I have set up the formula =IF(B2="Yes",A2+182,"NA"),and so one, for the further cells. This is successfully giving me what I need, which is to take the cells in column B in which I have been provided a "Yes" for recontact, look back at the date of initial...

Hi all Hopefully this is a fairly simple one. I have a form called DataEntry which has a field called ID which is an autonumber field which produces a reference number. Once the details are added there is are two buttons that can be pressed depending on the user. If command button 1 is...

Hello I have a mortgage comparison spreadsheet which, once the information has been input, compares the total amount payable over the initial fixed rate e.g. two years. Book1BC6Option One7Loan Amount (inc any fees added to loan)8Other Fees (not added to loan)9Term of Mortgage (in...