# initial

1. ### Automatic alphabetic data extraction macro needed

I came across someone in the office today that has been spending huge amounts of time on unnecessary copy/paste/sort gymnastics and it hurt my soul to watch. I know you geniuses can help me/her out so here's what she's doing... She's working with 3 spreadsheets; I'll call them Initial...
2. ### Required cell

ok, I've tried about 2 dozen methods to acheive this, so I'm putting up a post to see if anyone here can help me. Here's what I'm trying to acheive: I have a sheet with 10 columns Date Served, Last Initial, First initial, Zip, First Time Visit, Current month discount, over 60, Men, Women...
3. ### Put in "PIN" change to Initial

Ok, so I know how to do this using a back page sheet =IFS(Sheet2!B1=1234,"GM",Sheet2!B1=2345,"AP",Sheet2!B1=FALSE,"") But what I ultimately need and can't figure out is how to do this in the same cell. Rather than typing the "PIN" in Sheet2 B1 to input the initial in Sheet 1 M2, I need to be...
4. ### If Function Turnaround Time

I am hoping someone can help me, I have been trying to create a formula that would let our department track turnaround times. When I try Networkdays I get 1 on a same day turnaround. I fixed that by adding -1 to the formula. Now, I am trying to create either a If or Countif function - I...
5. ### Help needed - VLOOKUP based on IF statement, or similar

Hi there, I have a data set and Im trying to look up a specific value based on an initial look up in one column and then a secondary look up in another. So data would look something like this: A B C Apples Granny Smyth...
6. ### Removing Middle Initial from Last Name, First Name

Hello, A similar question was asked a few years ago, but in this case, I have a data sheet of names that look like this: Smith, John Q and I just want to remove the middle initial at the end, like: Smith, John Seems pretty simple, which is why I haven't quite figured it out yet...
7. ### Multiple Selections to P_rint

Is there anyway to take initials from a table (30 of them) and print a report using the initials as query criteria. Essentially you could select 10 initials and it would print the first report using the first initials, it would then go to the second initial and print, 3rd initial and so on...
8. ### Loop through VBA to join two columns prints properly, but I can't write to my destination column

I'm trying to join the contents of two columns, and have the new string appear in a third. It looks great when I use Debug.Print, but I can't get the new string to appear in the third column. Here's my print statement, which works great: Debug.Print Worksheets("TEST").Range("AJ" & i).Value...
9. ### XIRR Non Contiguous Data

I have cash flows in a table for a variety of contracts but initial investment values are separate and the investment dates are also separate, I have tried OFFSET etc but am struggling to make any sense of it. Example: B14..Z14 has the initial investment dates B15..Z15 has the initial...
10. ### vlookup

Hello All, I am looking to match the last name and the first letter of the first name for my employees and return the name as listed on another sheet based on the partial match. So on my first sheet ListBill I have the names listed as last name, first name and middle initial in column L. Column...
11. ### Formula

I am sorry if this has already been answered, I am not sure what to search for. I am trying to do something like a VLOOKUP, take a value to find and return data from a table. The problem is the initial lookup value will show up multiple times in the search table and I will need to choose...
12. ### Missing Digits.

I'm looking for a formula starting in K7 that will return the missing digits.The total digits are 0,1,2,3 that’s all and in row F7:H7 are my initial digits. Thank you <a href="http://tinypic.com?ref=2uegrx1" target="_blank"><img src="http://i64.tinypic.com/2uegrx1.png" border="0" alt="Image...
13. ### Calculating the "initial Investment Value" with CAGR formula and average value

I have been trying to rework a common CAGR formula to be able to calculate the initial investment value if all I have if the annualized rate and the average value over the term. So I know the standard formula is: The formula is: R = (F/I)^(1/Y)-1 R = annualized rate I = initial investment...
14. ### SUMIFS with Multiple criteria including UNIQUE value

Hi. I have the following sample data, I want to do Sum the Value in Column E if the following conditions are met The date is within the month of July 2018 The Person is Adviser The Type is Initial or Ad-Hoc The reference is Unique. Where all 4 conditions are met, I only want it to...
15. ### How to represent mathematical progressions or decays in EXCEL?

Hello! I have in a cell a number which is the initial amount and in another cell a rate of decay. That rate can be a number by which you reduce the initial amount or a decay percentage by which again you reduce the initial amount. How can I write a formula that will calculate the decay of this...
16. ### formula to calculate expiration date: last day of third succeeding calendar year

Hi, Can someone help with this one? Based on an initial date, need to calculate 3 years later end of year. Example: Expiration date is the last day of the third succeeding calendar year Initial date: 19/09/2018 End date: 31/12/2021 Thanks! Helena
17. ### Adjust height of a Cut Row now left blank.

This Macro moves a chosen Row to another workbook and pastes it , leaving a blank row in the initial workbook Sub OpenToSold5() ' Keyboard Shortcut: Ctrl+Shift+W Dim lRow As Long Dim lCol As Long Rows(ActiveCell.Row).Cut Windows("AMZ-GM Sold.xlsm").Activate lRow =...
18. ### Multiple formulas/conditions

I have a spreadsheet with a list of names for which I have to do lookups to in order to get specific information. In my data table I have: <tbody> NAME DIVISION ROUTE Smith J Technical 5268 Brown RS Legal 276634 </tbody> In my working sheet I have a list of names in col A as follows...
19. ### Get initial from name

How can I get just the initial of the name (ie in example below I want just L, C, R etc) Smith L Jones C Goodman R
20. ### PowerQuery - Filter to only earliest record

Hi I have a small PowerQuery issue which I am hoping one of you fine ladies or gents can help with My data is broadly as follows:- ID JobNo DateOnSite TimeOnSite 1 1234 01/01/2017 00:53 2 1234 02/01/2017 09:47 3 4567 02/02/2018 08:56 4 4567...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...