dynamic array

  1. staticfluids

    Distribute Number into Several Part (Increment) Based on Other Data (Dynamic Array)

    Hi all, I hope you're doing well. First of all, sorry for bad explanation as my main language is not English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula. It's quite helping with my daily Excel use. 2 of my latest question was asking about Dynamic Array...
  2. staticfluids

    How to Divide Its own Cell by Another Column Delimited Text (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...
  3. carpetony

    CountIf across columns, as an array functions, not concatenated.

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

    Trendline values using Dynamic Range in Excel - comparing with LINEST function

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

    How can I combine two tables?

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

    Use a Dynamic Range with Dates as a Criteria in FILTER Function

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

    There has to be a better way...

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

    Dynamic Average of top values in specific ranges

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

    Return multiple columns for each row with Dynamic Array INDEX/MATCH

    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?
  10. J

    Comma Separated Array List

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

    Lookup value using two separate dynamic ranges.

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

    Connecting Dynamic Table with Manual Static Data in Sheets

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

    Using Index with dynamic multiple columns

    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)
  14. D

    Using an array to dimension controls on a form to be added at runtime

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

    Spill dynamic array across multiple columns with a defined depth

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

    VBA Use dynamic array to create custom report

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

    Multiple a dynamic Range based on conditions

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

    How to Average Only Non-Zero Values Using AverageIfs with Index/Match

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

    Sumifs using unique and filter functions

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

    UNIQUE and CHOOSE for non-adjacent columns

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top