Search:

Tag: dynamic array

Page 1 of 3 1 2 3

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Extracting Unique Data from Repeating Parameters in Excel: Dynamic Approach Needed

    Started by nilaakash‎, 03-16-2024 04:35 PM
    dynamic array, excel 365 11 Attachment(s)
    • 442
    Last Post: 03-17-2024 09:36 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Dynamic Lookup That Omits Blank Rows In the Results

    Started by GeddB‎, 03-14-2024 11:59 PM
    complicated formula, dynamic array 2 Attachment(s)
    • 166
    Last Post: 04-03-2024 01:15 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Sumif with different sheets + dynamic start cell for indirect

    Started by vrrr‎, 03-07-2024 10:34 AM
    dynamic array, indirect & match, indirect address, sumif and index and match 1 Attachment(s)
    • 109
    Last Post: 03-08-2024 12:27 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Sumproduct with Dynamic Ranges

    Started by WaylettChris‎, 12-22-2023 05:19 AM
    dynamic array, reference cells, sumproduct 1 Attachment(s)
    • 138
    Last Post: 12-22-2023 06:54 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Array reference in custom formula without spilling?

    Started by EmilianoCarambano‎, 12-20-2023 08:50 PM
    dynamic array, lambda, spill 2 Attachment(s)
    • 227
    Last Post: 12-21-2023 01:40 PM
    by EmilianoCarambano  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Dynamic Array (FILTER) & expanding formulas

    Started by Red Barracuda‎, 12-07-2023 04:34 PM
    criteria, dynamic array, expand formula, filter, ifs and lookups 1 Attachment(s)
    • 212
    Last Post: 12-07-2023 11:44 PM
    by Gregb11  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Possible to add HYPERLINK to items in the same sheet, sourcing from a dynamic array?

    Started by pedromacloureiro‎, 03-02-2023 07:38 PM
    dynamic array, dynamic index, hyperlink 1 Attachment(s)
    • 304
    Last Post: 03-02-2023 09:44 PM
    by wk9128  Go to last post

    Forum:
    Excel General

  8. To spill Filter function wrapped in SUM Function

    Started by Vivek2705‎, 03-02-2023 02:39 AM
    byrow & lambda, dynamic array, filter, spill operator, spill range
    • 206
    Last Post: 03-02-2023 02:46 AM
    by HansDouwe  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] Dynamic array horizontal lookup across 2D range

    Started by Marbleking‎, 11-08-2022 12:27 PM
    dynamic array, horizontal lookup, spill range, xlookup 4 Attachment(s)
    • 538
    Last Post: 11-10-2022 04:27 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] MAX per row across columns with dynamically spilled array

    Started by Marbleking‎, 09-07-2022 09:17 AM
    dynamic array, max, spill range, table 1 Attachment(s)
    • 1,112
    Last Post: 09-07-2022 10:45 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Dynamic array formula to indicate which rows are visible and which are not

    Started by Marbleking‎, 09-03-2022 07:15 AM
    dynamic array, invisible rows, spill range, subtotal, visible rows 4 Attachment(s)
    • 1,506
    Last Post: 09-03-2022 11:12 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] Using Filter function with array criterias

    Started by kohno71‎, 05-23-2022 06:41 AM
    compound, dynamic array, filter, function, randarray 6 Attachment(s)
    • 542
    Last Post: 05-23-2022 01:28 PM
    by Bo_Ry  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Return multiple arrays on condition and append them with single formula

    Started by DWX57‎, 03-28-2022 11:36 AM
    append, condition, dynamic array, non empty cell, return 1 Attachment(s)
    • 385
    Last Post: 04-07-2022 10:02 PM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Dynamic Invoice summary right after last item row.

    Started by JJW_SG‎, 12-21-2021 04:18 AM
    dynamic array, invoice;formula;template, vba & macros 7 Attachment(s)
    • 676
    Last Post: 12-30-2021 12:17 AM
    by JJW_SG  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  15. [SOLVED] Dynamic array difficulty: LOOKUP/SUMIF/UNIQUE/FILTER/XLOOKUP based on multiple criteria

    Started by Rabk‎, 12-10-2021 12:22 AM
    dynamic array, sumif, unique, xlookup 4 Attachment(s)
    • 814
    Last Post: 12-10-2021 02:17 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  16. Can I parameterize vlookup?

    Started by hcohen‎, 11-25-2021 05:13 AM
    dynamic array, dynamic array names, vlookup 1 Attachment(s)
    • 351
    Last Post: 11-25-2021 09:20 AM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Using SUMIF with Dynamic Arrays to sum column totals

    Started by Matt7777777777‎, 11-16-2021 09:50 PM
    dynamic array, sumif 3 Attachment(s)
    • 514
    Last Post: 11-19-2021 02:04 AM
    by DJunqueira  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] Sequence formula

    Started by jonfredrikheen‎, 11-02-2021 03:38 PM
    dynamic array, help a dummy, sequence 1 Attachment(s)
    • 382
    Last Post: 11-02-2021 06:41 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] Check data in a table array that changes

    Started by Baabaa‎, 10-17-2021 11:17 PM
    dynamic array, index and match
    • 266
    Last Post: 10-18-2021 05:34 AM
    by Baabaa  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Filter dynamic array to keep rows which include conditional minimum values

    Started by Marbleking‎, 10-08-2021 07:37 AM
    dynamic array, filter, minimum 2 Attachment(s)
    • 442
    Last Post: 10-11-2021 04:33 AM
    by Marbleking  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] Dynamic array to replace pivot table (sorting problem)

    Started by Noneto‎, 06-26-2021 12:07 AM
    dynamic array 3 Attachment(s)
    • 687
    Last Post: 06-26-2021 03:52 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  22. Conditional MIN and RANK using dynamic array formulas

    Started by Marbleking‎, 05-07-2021 02:48 AM
    conditional calculations, dynamic array, minifs, rank 1 Attachment(s)
    • 694
    Last Post: 05-11-2021 04:42 AM
    by Marbleking  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Conditional MAX and RANK of 18-digit text numbers using dynamic array formulas

    Started by Marbleking‎, 05-04-2021 04:28 AM
    conditional, dynamic array, large numbers, maxifs, rankif 2 Attachment(s)
    • 513
    Last Post: 05-06-2021 07:41 AM
    by Marbleking  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Function to track how many items different warehouses have received / sent

    Started by voxcon‎, 03-26-2021 12:53 PM
    dynamic array, filter, unique 4 Attachment(s)
    • 467
    Last Post: 03-26-2021 02:08 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Sumproduct with a dynamic moving range

    Started by sachindmnc‎, 03-11-2021 06:38 AM
    dynamic array, sumproduct 2 Attachment(s)
    • 750
    Last Post: 03-11-2021 12:07 PM
    by sachindmnc  Go to last post

    Forum:
    Excel Formulas & Functions

  26. Cumulative sum with dynamic array formula

    Started by Marbleking‎, 02-10-2021 10:31 AM
    cumulative sum, dynamic array, spill range 2 Attachment(s)
    • 2,589
    Last Post: 02-10-2021 12:10 PM
    by Marbleking  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Dynamic Array Searchable Dropdown

    Started by LKERN‎, 01-24-2021 03:05 PM
    dynamic array, filter argument 2 Attachment(s)
    • 505
    Last Post: 01-24-2021 04:18 PM
    by LKERN  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Formula - Sum and multiplying - Dynamic array spilled behavior

    Started by ttch‎, 11-30-2020 12:55 PM
    dynamic array, excel, macro, vba 5 Attachment(s)
    • 551
    Last Post: 11-30-2020 02:54 PM
    by ttch  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Dynamic Validation List using a qualifier column in Excel 2016

    Started by CharlzNine‎, 11-20-2020 05:33 PM
    dynamic array, formula and if statement, validation list 1 Attachment(s)
    • 426
    Last Post: 11-21-2020 04:26 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Formulas & Functions

  30. [SOLVED] Filling in gaps in rows by deducing relationships across table

    Started by Marbleking‎, 09-11-2020 12:39 PM
    deduction, dynamic array, filling in gaps, spill range 3 Attachment(s)
    • 433
    Last Post: 09-13-2020 05:14 AM
    by Marbleking  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Filter Causing SPILL# in IF Formula

    Started by Fugdkn‎, 08-18-2020 04:15 AM
    count a, dynamic array, filter, office 365, spilled range 1 Attachment(s)
    • 1,167
    Last Post: 08-18-2020 06:29 AM
    by XOR LX  Go to last post

    Forum:
    Excel Formulas & Functions

  32. [SOLVED] How can I add a new item to a dynamic validation list without adding to source table

    Started by chris01395‎, 04-17-2020 05:39 AM
    dynamic array, validation list
    • 364
    Last Post: 04-20-2020 06:58 AM
    by chris01395  Go to last post

    Forum:
    Excel Formulas & Functions

  33. SUMPRODUCT with a dynamic array or any alternative might help

    Started by aria24‎, 04-04-2020 03:52 AM
    dynamic array, last active cell, sumprodcut 2 Attachment(s)
    • 828
    Last Post: 04-04-2020 06:52 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  34. Dynamic Filter Formula w/criteria list

    Started by chrisTXACC‎, 03-24-2020 01:54 PM
    dynamic array, filter, formula and if statement, list 2 Attachment(s)
    • 1,174
    Last Post: 03-28-2020 02:30 PM
    by Fluff13  Go to last post

    Forum:
    Office 365

  35. Countifs / Sumifs with dynamic arrays (spilled ranges)

    Started by esbencito‎, 02-26-2020 05:36 AM
    countifs, dynamic array, spilled range, sumifs 1 Attachment(s)
    • 7,556
    Last Post: 03-08-2020 02:43 PM
    by rorya  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 74
Page 1 of 3 1 2 3

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1