dynamic arrays

Hi all, I would like to color the diagrams "Result" automatically according to the specified color. However, the diagrams should be based entirely on the arrays and adapt themselves completely dynamically. --> For example, if I add "Spain", Spain should also be added in the color green in all...

I have a source table that is only populated by formulas, there is no hard data. It's also dynamic so a few rows will only have formula but no retrieved data. The difficulty is dates in pivot tables and graphs: if there are empty rows then the dates column won't group or be recognised as dates...

For weeks I've been trying to find a better way to make a Wind Rose Chart or a Spiral Bar Chart to keep track of my Achievements in Steam. I tried to ask AI-aided Formula Editor but it's either not working or I'm not asking the right questions. I'm trying to find a better way to write the...

I have this table where I'm trying to filter all non closed projects numbers. So, I use a filter keeping only the "Current status" I want: Active Clarification On Hold To initiate Closing Despite this, there is still 1 CLOSED that appears I tried another way having a filter...

Hello, If anyone can help me understand the inner workings of this code, I'd greatly appreciate the help. ' in code module for clsRunTimeCheckBox Public WithEvents Checkbox As MSForms.Checkbox Event Change() Private Sub Checkbox_Click() Set UFParent.ActiveCheckBox = Me RaiseEvent...

Hello, I'm trying to determine if it's possible to combine multiple arrays of dynamic data into one vertical array. I've tried using a SORTBY function in Cell A7 but it seems to try and combine the arrays horizontally. Is there a way to combine dynamic data vertically...

Hi!! I am traying to sum all the days that has elapsed between the origin date and a fixed given date when some conditions happen to occur. I copy below a sample. DATE (A) SOLUTION (B) 05/05/2021 10/05/2021 10/05/2021 10/07/2021 20/05/2021 20/07/2021 20/05/2021 30/05/2021 25/05/2021...

Hi! I am having some difficulties with my dynamic arrays I need to create two different dynamic arrays, in which I extract the Top 5 values aggregated by "Case". In the first scenario, I would need to obtain the Top 5 values when...

Hello Excel comunity, I started playing with dynamic arrays to replace PivotTables. It s working well but I am struggling to order the data in the way I need. I wonder if is possible to make this Dynamic Array table without using the Auxiliar Table. Here is an example: Formulas...

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

Hi! So I want to make a Dynamic array with Choose, where one column will be the unique clients and in the second column I want the SUMPRODUCT of Quantity and Price for each product. As you can see the result is 0 for each row. This is just an example of my real problem with a report of 200K...

Up until the arrival of dynamic arrays to Excel I ran Monte Carlo simulations using the DATA TABLE as in range D2:D11 in the example below. Notice that each cell in that range is an independent trial of the computation in D2. Now, if I want to change the number of trials, I have to retype the...

Setting Suppose I want to have the numbers from 1 to 10 generated in the range B1:B10. I can store N in A1 and type =SEQUENCE(A1) in B1. A dynamic array is generated that gets the job done. My problem I have an arbitrary computation in A2 that I want to copy 10 times in the range C1:C10. I...

Hi Guys, I have been trying to get results from SUMPRODUCT based on the data for volumes and %s which need to change every year but so far have no success. I have attached a mini-sheet below which shows what the result should be like. Any help is much appreciated. Thanks in Advance.

If you have a cell containing a text string with spaces in it and you want to split it by spaces into columns, you can easily do so by using the Text-to-Columns functionality. Or you can use Power Query to clean up and split everything. Or if you want to use formulas, this algorithm can help...

As of November 26, 2019, the Excel team has announced that Dynamic Arrays have rolled out to 20% of Office 365 Subscribers on the Monthly channel. This means tens of millions of people are getting their first look at SORT, SORTBY, FILTER, UNIQUE, RANDARRAY, and SEQUENCE. In my seminars, I...

This is not looking for a solution its more so advice on if its possible. Was looking to create a dynamic floor plan in Excel where on the raw tab you would enter certain dimensions of a piece of equipment and it would then map it on a sheet. Something like Item A being 6*3 meaning its 6...

I have a workbook that will be my main program. From this workbook I need to do the following in VBA. 1) Reference external workbook (hardcoded location). 2) Create arrays based on the sheet names in this external workbook 3) Populate each array with the table data in each worksheet once the...

Hi Guys, I am trying to make myself a dashboard that is updating itself as much as possible. I have one data sheet with all the source data which is in the following format: <tbody> Startdatum new members New member % page views visits 4.1.16 wk 1 0 0 0 0 11.1.16 wk 2 0 0 0 0...

HI, I have a fixed asset register set up as follows: Cell A1 date Col A - Location Col N to Y - Jan to Dec. Each column contains the monthly depreciation value for each asset. I need to do a sum based on the location, but I need the sum range to change to give me the YTD values. so for...