dynamic formula

See attached picture for the detail: Question: The output for column D, E, F should be using the number in column C * % starting from 100% all the way down to year of 21; however, the installed number in column C can happened in year 5,6, or any year, how to make the calculation in column D...

Hi, first of all, sorry for my bad English. I have been looking for a solution here, trial and error by myself, and the Microsoft forum as well. But haven't found any solution that satisfies the needs. I think it's possible but I don't know how to put it into Excel formula. The logic is like...

I'm brand new to VBA and Macros, having had the luxury of relying on statistical programming languages like R and Python up until now. Due to some restrictions at my workplace that won't allow me to use R Shiny or Python Flask for the task at hand, I am looking to make what is effectively a...

Hello! I'm trying to make a dynamic reference to a closed workbook in my report. Currently, a straight-up hardcoded link looks like this: ='G:\Reports\Management Reporter\[India Trial Balance 2023 in US dollars v2.xlsx]ManagementReporterISbymonth'!J16 My goal is to have the bolded part be...

Hi All, I am looking for some help with a dynamic percentage change formula. I have quarterly data of purchase price per unit (2019 - 2021) for each product. Some products were not purchased each quarter so I need a formula that would use the most recent purchase in those instances(i.e...

Good Day all! I appreciate the ability to read others posts and make sense of my own code...but this is a doozy! I have read so many posts, and I know it's probably a missing single/double quote... or maybe I'm missing it all together... I have 3 workbooks open and I have been able to store...

Hi I can't find the answer in the archive. I want to dynamically (ie without refresh/F9) use the value at the cursor position in a formula. so assume I've a list of values in A1....A5 5 10 15 20 and as I move the cursor down the list I want a formula in another cell to use that (for example...

Hello experts, I need your help to know what formula should I apply to get dynamic results. In the attached spreadsheet I have sample data of my monthly report, where we have monthly actual column and remaining month forecast (M05 to M12). I also have monthly budget and monthly forecast...

I am stuck trying to convert this dynamic formula to use the CONCATENATE function instead of the &s. I am using an Excel add-in that does not accept "&" in formulas. I have tried several times to do this myself but cannot figure out what I am doing wrong. It doesn't seem to play nicely with the...

I have multiple sheets - 1 is an index and the rest are project sheets 1801, 1802, 1803.... The index has a column "B" that lists all the project sheet names. I am trying to determine the last populated date in each project sheet - also column B. I am able to determine the last populated date...

Hey Guys! I immensely need your help for the below scenario. I am trying to find a way to address range in a formula. The problem is that, the range is created dynamically. Please refer below image further. Here I have 2 tables say Table 1 & Table 2, these tables are snippets of my actual...

I'm not entirely sure how to nest a string of IF functions with a LEFT function. My IF function is as follows (located in cell W2): =IF(I2<>0,I2&", ", "")&IF(J2<>0,J2&", ", "")&IF(K2<>0,K2&", ", "")&IF(L2<>0,L2&", ", "")&IF(M2<>0,M2&", ", "")&IF(N2<>0,N2&", ", "")&IF(O2<>0,O2&", "...

I am looking to use a dynamic formula to show contents of multiple cells comma separated in a single cell. For example, I have a range of 10 cells (horizontal) that may or may not contain a value. I would like the formula to simply show what values are in that range and update as data is...

Hello, I have used the INDIRECT in a bunch of workbooks to dynamically create formulas based on 1 or multiple cells. Usually to reference a worksheet tab name based on date or function. A3 = 10012015 (cell formatted as text as I need leading zeros) E.g...

Hi, I am trying to create a formula that brings back a month number based on where a value is input. For example I have month 1 to 48 in column B from B1 to B40 and in column G1 to G40, I would place randomly the value 1000 aligned with Column B months for example months 1-13-19 etc. In...

Hi All, I hope that I'm just missing something simple here -- I can't get the following code to work. Sub sumfornondddgrid() Dim lastrow As Integer Dim lastcolumn As Integer Sheets("02Grid by Dept and GLCode").Activate lastrow = Cells(Rows.Count, "B").End(xlUp).Row lastcolumn = Cells(1...

Greetings, I have data in the range P14:P28. I wrote a macro that appends a new data point at P14 every time the macro is used, which increases the range of the column to P14:P29, and also calculates the average of the new range (P14:P29) in cell P31. The problem is that I need the formula to...

Greetings, I have a table in the range D14:N28. I wrote a macro that appends a new year of data at row 14, which increases the range of the table to D14:N29, and calculates the percent change for each column in row 31 (e.g. (D14-D29)/D29 ect.). The problem is that I need the formula to be...

I have made a table with many dynamic formulas that I want to import into the Name Manager. It has the names in Column A and the "Refers to" formulas in Column B. Unfortunately, when highlighting the cells and using the "Create from Selection" feature of Excel 2010 it puts the Column B cell...

Ok, so I'm probably just not using the correct search terms (wouldn't be the first time), but I'm on a bit of a time-crunch with this one: I have a list of numbers which match up to a defined cell name on a different sheet. I'm hoping to make the results variable. For example what I currently...