dynamic array

Hi all, i hope you're doing well. First of all, sorry for bad English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula lately. It's quite helping with my daily Excel use. I have a one case where i want to divide its own cell using a value from another cell...

I have one large table, I want to summarize via CountIf, the number of entries in other columns associated to the specific companies. I need to create the summary table on the fly with VBA, and was hoping to have to input the fewest functions necessary, and was hoping it could do a Vertical...

Hello, I'm going to first explain in detail what I'm getting so that there's not confusion. I have the following data in subsequent columns: time(s), volume(cm3), volume(m3), time/volume(s/m3). So, as you can see, the first 2 columns are 'input type columns', in which I insert the values from...

Hello - I have two tables across two worksheets. Table 1 has activities/tasks (approx. 200) down column A and named individuals across row 1 (approx. 25) with input data being added into the table, say B2:Z200, so that you can assign one or more named individuals to an activity (and the same...

So I manage to create a dynamic range of dates with all the 1st of month between a period of time. What I want to do, is sum all the expenses of respective month from another table. That result should be another dynamic range of the same size as the one with the dates in order to create the...

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

Hi everyone. Im trying to find the average of the top values of several- non continued ranges. see image for reference: What I need is being able to average the TOP value of range B4:B15 with the TOP (the ones in green) value of B17:28 and so on for the next following cells that are not in...

Hi, I'm wondering what the best way is to return all columns (T and U) in the following setup: I have tried using BYROW/LAMBDA to no avail. Perhaps there is a better function than INDEX/MATCH for this?

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

I have created two custom formulas that each return a two dimensional array that result in dynamic arrays that spill to adjacent fields. The following examples are a mockup of my actual formulas as they are large. Dynamic array 1 is on it's own sheet called "Orders" and looks like this: Custom...

Hi All, first time poster, long time lurker! Problem: Gym churn report. Client details are imported from a CRM who match criteria (not attended a class for 30 days). The Trainers then manually add if they contacted said member and add notes. When this list is refreshed and client data gets...

Hi Community, is there a way to get INDEX to work with multi-column select dynamically. This Works: INDEX(Table,,{3,5,9}) This Throws an Error: INDEX(TABLE,,{COL_A,COL_D,COL_C}) EDIT: Just an FYI; this also works: INDEX(TABLE,,COL_D)

have the following code in my user form which uses a class module (not shown). It all works great, but I want to add the buttons dynamically according to a list in my worksheet and don't know how to use an array to dimension them. At the top of my user form I Dim the events references: Dim cbe1...

Hello Is it possible to distribute a dynamic array into multiple columns? For example, consider an array with 22 values, and you want to spill the values in sequence across 6 columns with a maximum row count of 4: In this example a have put numbers in sequence for the sake of simplicity, but...

Please assist if you can! I have an exported Excel report, each row is a new customer, but the rows stop at 137. There are about 250 columns with customer details, but only 5 columns belong to 1 customer in each row. My boss wants me to format this report to reflect each customer in individual...

Hi everyone, I have a bit of convoluted question regarding multiplying dynamic amounts based on date and time conditions. I have tried a fair few different formulas including sumproduct, vlookup and ifs - but nothing gives the right answer. This is quite a large sheet so I have only copied...

Here is my current formula: AVERAGEIFS ( INDEX ( $H$10:$X$505, , MATCH ( [SKU], $H$10:$X$10, 0)), $E$10:$E$505, [City], $F$10:$F$505, [Store Name]) I am trying to summarize the average prices (H11-X505) by product (header cells H10-X10), city and store (Columns E-F) in a separate table using...

Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...

Hi Everyone, I have an issue with a formula and I have been told we have all the experts in the world to answer to this question. I am trying to get a list of unique values for 2 non-adjacent columns. I have tried the formula below but it doesn't work. It only spills the result for one single...

Hello, I'm betting there is a better way to run this formula that references a block of dates by month, and returns the table rows based on the short date related to the selected month. In the example below, I have a dynamic array showcasing the rows of data from a table based on the month...