initial

  1. T

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Some videos you may like

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...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top