years

MP3 files have imbedded metadata that I would like to edit. I have between 35K and 40K files that I would like to edit one or two fields in each. I would also like to export to an Excel database a selection of fields: Title, Artist, Comment and so on. I can open each individual file in File...

Hello forum friends, can someone please tell me what is wrong with this formula? I keep getting the error that I have entered too few arguments. =index(B55:B116,match(year(now)),A55:A116,0)) Column A has years in it and column B has dollar amounts. Excel 2016 (Windows) 32...

Trying to piece together a formula that will combine a bit of text with COUNT results from a worksheet called 'payroll'. Perhaps I should start with what I want the finished result to look like. The formula, which is on a worksheet called 'income_analysis', would return the following...

Hey guys, I have a bar chart with two values for a given year and this done over a 5 year period. For example blocks highlighted blue will be ascending over time with amounts increasing each year and orange will be decreasing each year Can the difference between the total summed values for...

I'm trying to find the required corpus for the following: Present Value = 200,000 20 years to retirement 30 years total retirement Projected inflation = 2% Projected growth = 6% Annual withdrawal will be $115,000 To meet the $115,000 with 2% inflation and 6% growth requires a corpus of...

Hello, First off, appreciate any help as I a have been banging my head on this for some time. I want to see if there is any guidance on how to do a mean reversion forecast in excel. The data points are very simple and are linked below for your reference...

My workbook sheet tabs would be named by Year (i.e. 2018, 2019, etc). Currently I have one sheet (i.e. 2019). I would like to display in a combo box the previous 2yrs (i.e. 2018 & 2017) and also the following year (i.e. 2020). Maximum years displayed should be limited to 4. (i.e. 2017 -...

I am working on a spreadsheet for monitoring personnel records, especially in relation to the disposal of the records. I current have the spreadsheet which calculates 6 years after an employee left, and which will compare this to today's date to flag they have been gone for 6 years. Our policy...

Hi Guys Just curious if someone knew had to do a complicated "sumif" calculation where you take the criteria in a list from the columns and the rows. What I am trying to do is add up all the quarters in a specific year (say in this case 2018) and add only 2018's quarters along with the...

I'm treasurer of my HOA and every year I save my current Budget workbook, and create a new one using Save As and incrementing the integer by 1. For example, MB18 gets Saved As MB19. I then clear the data using a macro to start the new year. One of the problems with that is I don't get last...

- I have historical data for every NASDAQ stock for two years (~50k rows worth). - I have calculated an 'After-Hours' percentage gain for each of these NASDAQ stocks for the past two years (Column E). - I need to filter out, by each date, only the top 10 performing After-Hours Gainers. Data...

I have a mortality table for 100 people, and I'm trying to calculate the expected deaths each year for 20 years. This requires me to calculate the probability of one death and multiply by 1, then calculate the probability of two deaths and multiply by 2, and so on up to 100. The setup of the...

Okay, my brain is cramping but I'm pretty sure this problem I'm having can be solved by someone a lot brighter than I am. The two columns in question, columns B & C, need to work together for my worksheet to be accurate. They need to be able to account for users who are younger than 70...

Hello forum friends! Okay, this one is complicated (at least for me). However, I am hopeful that someone will be able to help me. There are three sheets involved and the formula in question resides on the ‘income analysis’ sheet in cell D97. The formula works fine for all intents and...

Hi, I have some data that is represented in decimals. I want this data, in a different cell to be represented as months. For positive values it works fine, however for negatives it does not. My initial formula was as follows: =IF(AJ5="","",(IF(INT(AJ5),INT(AJ5)&" Years...

Hello World, My work is upgrading Office 365 and I've seen a demonstration of MS Flow which looks like the personal automation revolution that Excel VBA was 20+ years ago. I've learnt so much from this forum but now I am wondering if there is a forum for Flow. I wait with baited breath, Thanks,

Hello, I have a Google Form which will be used to register animals for a spay & neuter clinic. One of the questions is "Age". I have multiple choices in Col A which include text. I want those choices to turn into numbers in Col B. I intend to report stats based on age groups in Col C. 1) Is...

Hello forum friends, would like to know if it's possible to convert a decimal to months of age. I have a formula that is returning "Started pension at 63.5222222222222 years of age" and I think it would look a lot better if it returned "63 years 6 months of age". The return does not need to...

Hi all, I have created a userform, There are 2 conditions The 1st condition with optionbutton1 and obtionbutton2 (they represent either ''Male'' or ''Female'') The 2nd condition with optionbutton3, optionbutton4, optionbutton5 and optionbutton6 (they represent ''less than 18 years old"...

if Cell A1 equals 53 months, I want B1 to equal 4 years 5 months.