initial

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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