dynamic range

Hi, Hoping someone can help - I'm trying to add an additional condition to the below formula to check whether the value exists in another (dynamic) range, however the best I seem to be able to get is that it compares value 1 with value 1 and value 2 with value 2. For clarity, "main_data" is...

Hello Everybody! I'm trying to calculate a percentile on a dynamic named range that references two non-contiguous ranges and not having success. First I tried using a static named range and it worked. Then I made the named range dynamic, NMFL_Load, using...

Hello all I am hitting a brick wall. I am trying to create a reference based off of a dynamic range, however if the sheet is not active I keep getting an error for out of scope or application-defined or object-defined error. The dynamic range is made through special cells since the data often...

Hello, I have a macro that runs Solver in Excel, it currently uses two different ranges as the variable cells. See the code below. SolverOk SetCell:="$D$27", MaxMinVal:=2, ValueOf:=0, ByChange:= _ "$C$17:$C$23,$C$7:$I$11", Engine:=1, EngineDesc:="GRG Nonlinear" SolverOptions...

Hi, I am trying to make an line/scatter line chart for trend analysis where there are x-axis and y-axis values in two different columns. In the attached image, I would like to use columns D and I as x-values and E and J as y-values. However, I want the points to display in order of the x axis...

HI to all, here another question: I have attached the Cotizaciones (sheet 1) , Retornos (sheet2) and Descriptiva (sheet3) . From data in Retornos (sheet 2), for each column (are dynamics) starting from B3, I have to compute calcolation of average and the volatility (until last row for each...

Hello, I'm calculating Split Multiplier column from Split Ratio column by multiplying the rows from the current row towards the end of the column. It works nicely within normal excel table with PRODUCT($B3:INDEX(B:B; ROWS($B$3#)+ROW($B$3)-1) ) where the formula is copied down, but if I try to...

I'm trying to create a user-friendly timesheet for someone who has never used Excel. How can I create a dynamic range linked to a pivot table with the formula cells locked? I can do dynamic or locked cells but not both. What am I doing wrong? And I'm VBA ignorant, can this be done manually...

Hi Guys, I am trying to create a formula where I can draw data from a dataset which has 3 fixed ranges, 2 fixed criterion and 1 dynamic criteria. As I have shown in the uploaded images, there are the months, types of items and customers. All this data is drawn by a VBA code to the raw data...

Hello team, I would like to ask for help with the following macro as I just can't figure it out, I tried so many versions but nothing worked for me. I need to remove all rows in my sheet that do not contain value greater than 50 in any cell in a given row. That means that if the value is less...

I have a sheet in which there would be a dynamic range with static columns and dynamic rows, Range("A1:Y1892").Select **(need this range to be dynamic, which can be furthure used in power query) Range("J19").Activate Application.CutCopyMode = False...

Hello, I want to create a X/Y scatter chart to plot projects Final Amounts Invested amounts & % and use slicers to select one or more than one location. I have numerous locations and each location has a different number of projects to be included. This number of projects changes each month...

Hi all, I have a problem, I want to calculate the mean of daily production over a period of time, but this period is very different per case. Below you can see one case, in reality the row is much longer but for practical reasons in shortened the different periods. The top row indicates the day...

Hi Guys I am using solver to identify from multiply amounts which add up to a specific number. I would like to make the "By change " to a dynamic range that will work no matter how many values are entered . I've been trying this for now 3 weeks and would appreciate someone helping me with the...

I need to create a range between B5:M5 that is defined by the location of P1 (phase 1) and P2 (phase 2) in Row 4. The range should begin one column to the right and one row down from P1 and end at the cell one column to the left and one row down from P2. P1 and P2 are both movable and so...

I am attempting to retrieve the value found in the last cell/row in column E of a dynamic range. The first row containing data will always be E12 and the last row fluctuates on a daily basis. The formula I am using invariably returns the value found in E12 only - so I am obviously doing...

HI Guys need some help with this one - Done some searching but couldn't find anything that helps with my particular challenge here The excel function I would to return via vba in Cell L3 is =SUMIFS(G3:G12,H3:H12,"Sales",I3:I12,"<>Excluded")/38 I want to achieve this using VBA and use...

I have a dynamic range that all the info in is 1 row and I want to use it to populate a combo box but I can only get the value in the first cell to show in the combo box. Range named adbk is on a tab named Admin and the data starts in b1 and stretches out on row 1 below is the line of code that...

Hello everyone!! Hopefully somebody can help me! I am using VBA to create an email from Excel that includes in the body of the message a table that I am selecting as an specific range. The problem that I have is: I have not been able to select just the dynamic range that contains values. It...

Hello! I'm new here, so please let me know how I can best improve for future posts... My question is about a VBA loop in a file. I am trying to create a program that takes all the cells in a range (the range is a dynamic named range, but for this example, it's 269 rows and 37 columns), checks...