Search:

Tag: array

Page 1 of 34 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. [SOLVED] Index match with multiple criteria

    Started by Marbleking‎, Yesterday 07:19 PM
    array, index, match 1 Attachment(s)
    • 93
    Last Post: Today 07:37 AM
    by Marbleking  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Juxtaposing successive levels from parent-child relational data

    Started by Marbleking‎, 07-01-2020 04:35 PM
    array, hierarchical structure, parent child, relational database 10 Attachment(s)
    • 500
    Last Post: 07-08-2020 11:41 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] Excel Table lookup Named Range

    Started by revocats10‎, 06-27-2020 05:16 AM
    array, excel named ranges, table, vlookup 3 Attachment(s)
    • 106
    Last Post: 06-27-2020 06:55 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Create Singular record from a Zip Code Range table

    Started by zoso333‎, 06-23-2020 08:07 AM
    array, index and match and if, offset 2 Attachment(s)
    • 113
    Last Post: 06-23-2020 09:33 AM
    by zoso333  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  5. [SOLVED] Create a VBA subroutine named JumbleArray from a preexisting (m x n) array

    Started by Lance15‎, 06-16-2020 09:22 PM
    array, vba, vba & macros 3 Attachment(s)
    • 229
    Last Post: 07-04-2020 12:59 AM
    by nisarga  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  6. [SOLVED] Multiple IF conditions in ARRAY formula

    Started by pritesh118‎, 06-16-2020 01:41 PM
    array, multiple and, multiple if, multiple or 1 Attachment(s)
    • 110
    Last Post: 06-17-2020 07:59 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Poll: Multiple columns sorting with "date" column using an array function rather than sort.

    Started by DexterStagg‎, 06-13-2020 01:12 PM
    array, column, date, sort 1 Attachment(s)
    • 133
    Last Post: 06-14-2020 10:42 AM
    by Gregb11  Go to last post

    Forum:
    Excel Formulas & Functions

  8. If value is in array then copy row to another sheet

    Started by DanzaNZ‎, 06-10-2020 01:54 AM
    array
    • 116
    Last Post: 06-10-2020 07:56 PM
    by DanzaNZ  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  9. Array formula data limits

    Started by Eelman‎, 06-07-2020 07:26 PM
    array, array formula, sumproduct array
    • 107
    Last Post: 06-07-2020 09:13 PM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  10. =SUM(countifs with two set of multiple data

    Started by ciaron178‎, 06-04-2020 11:59 AM
    array, counifs, countifs or, formula, sum 1 Attachment(s)
    • 103
    Last Post: 06-04-2020 03:42 PM
    by XOR LX  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Auto Categorize Products

    Started by Gidion‎, 06-04-2020 07:35 AM
    array, categories, vlookup 2 Attachment(s)
    • 120
    Last Post: 06-04-2020 10:23 AM
    by Gidion  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] Match and Condense from Dataset

    Started by sonoamore‎, 06-02-2020 07:16 AM
    array, condense, index 1 Attachment(s)
    • 64
    Last Post: 06-02-2020 07:34 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Adding Only Visible Cells to Array Concept

    Started by rastawolf‎, 06-01-2020 09:02 AM
    array, conceptual, filtering, visible cells
    • 101
    Last Post: 06-01-2020 10:36 AM
    by xladept  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  14. [SOLVED] Transforming Data Within An Array

    Started by larryg003‎, 05-28-2020 09:08 PM
    array, lookup, small 2 Attachment(s)
    • 91
    Last Post: 05-29-2020 10:24 AM
    by larryg003  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Is it Possible to Make an Array Length Dynamic?

    Started by larryg003‎, 05-28-2020 04:46 PM
    array
    • 85
    Last Post: 05-28-2020 05:04 PM
    by RaulSerg  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] I need to extend my range from my limited arrays.

    Started by jengjava‎, 05-28-2020 12:03 PM
    array, condition, loop, steps, vba 1 Attachment(s)
    • 197
    Last Post: 05-31-2020 09:44 AM
    by dangelor  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. [SOLVED] A formula that looks at another table and returns all rows with a certain value

    Started by dbl_dbl‎, 05-26-2020 04:53 PM
    array, return all matches 1 Attachment(s)
    • 183
    Last Post: 05-28-2020 05:03 PM
    by dbl_dbl  Go to last post

    Forum:
    Excel Formulas & Functions

  18. UNIQUE function works until converted to table

    Started by benfsanders‎, 05-21-2020 06:03 PM
    array, unique
    • 119
    Last Post: 05-22-2020 01:48 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Index/Match Formula Translate to VBA

    Started by Mgeiss‎, 05-19-2020 10:16 PM
    array, if statement, index, match, vba
    • 84
    Last Post: 05-19-2020 11:33 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  20. Random item from a conditionally filtered array

    Started by bugsibugs‎, 05-18-2020 09:13 AM
    array, conditional, filter, random, range 2 Attachment(s)
    • 92
    Last Post: 05-18-2020 05:48 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  21. formatting for individual cells on one column based on drop downs from another

    Started by dean012011‎, 04-30-2020 08:01 PM
    array, conditional, formatting, list
    • 70
    Last Post: 04-30-2020 08:21 PM
    by David A Coop  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] I need some help with an Index and Match function

    Started by deniseb27‎, 04-29-2020 11:59 AM
    array, index, match 4 Attachment(s)
    • 135
    Last Post: 04-29-2020 05:08 PM
    by etaf  Go to last post

    Forum:
    Excel Formulas & Functions

  23. Help speed/clean up frequency formula

    Started by clickheredk‎, 04-24-2020 04:49 PM
    array, frequency, speed; clean; slow
    • 124
    Last Post: 04-25-2020 05:20 AM
    by XLent  Go to last post

    Forum:
    Excel Formulas & Functions

  24. Show value if between multiple date ranges

    Started by msmsmsms‎, 04-19-2020 02:16 PM
    array, if formula, sumproduct 2 Attachment(s)
    • 132
    Last Post: 04-22-2020 03:54 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Assign value on 1 column based on sequence on another column

    Started by kw42chan‎, 04-07-2020 06:32 AM
    array 4 Attachment(s)
    • 129
    Last Post: 04-08-2020 07:03 AM
    by Marc L  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  26. [SOLVED] Sum Prices with Criteria from Two Lists

    Started by wharles62‎, 04-04-2020 10:42 PM
    array, dsum, lists, multiple criteria, sumifs 5 Attachment(s)
    • 205
    Last Post: 04-06-2020 08:13 PM
    by wharles62  Go to last post

    Forum:
    Excel Formulas & Functions

  27. How to display a list rows with matching values from a second worksheet

    Started by imaquila‎, 04-05-2020 02:43 AM
    array 1 Attachment(s)
    • 97
    Last Post: 04-05-2020 02:44 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Single Array Sum Every N Rows?

    Started by smitpau‎, 04-02-2020 11:18 AM
    array, nth row, sumproduct
    • 89
    Last Post: 04-02-2020 12:04 PM
    by JBeaucaire  Go to last post

    Forum:
    Excel Formulas & Functions

  29. listbox array filter has blanks

    Started by rbeech23‎, 04-01-2020 08:56 PM
    array, listbox, vba 9 Attachment(s)
    • 276
    Last Post: 04-03-2020 08:17 AM
    by rbeech23  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  30. Look up across columns by Date Range and Return multiple matches

    Started by alehouse1971‎, 03-25-2020 11:01 AM
    array, return all matches 3 Attachment(s)
    • 135
    Last Post: 03-26-2020 09:55 AM
    by MarvinP  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Using Match/Index in macros

    Started by Apple_sin‎, 03-19-2020 07:27 AM
    array, formula, macro
    • 90
    Last Post: 03-19-2020 10:50 AM
    by Kaper  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  32. Need Help Changing a Working Macro - Array Issue?

    Started by taylbren‎, 03-16-2020 05:09 PM
    array, sheet array, vba
    • 104
    Last Post: 03-17-2020 04:39 PM
    by PCI  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  33. Count occurrences within range where criteria is drawn from cells in same range

    Started by AaronAudio‎, 03-16-2020 03:19 PM
    array, countif, index, match, occurrences 3 Attachment(s)
    • 160
    Last Post: 03-19-2020 10:20 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] trouble with averageif combined with "<>0" formula, "too few arguments"

    Started by az1234‎, 02-11-2020 02:40 PM
    array, averageifs, function 1 Attachment(s)
    • 113
    Last Post: 02-11-2020 03:01 PM
    by CK76  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Prevent duplicates when selecting random string from list

    Started by tulipxde‎, 01-30-2020 06:32 PM
    array, duplicate, excel, list, randbetween 2 Attachment(s)
    • 138
    Last Post: 02-02-2020 01:09 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 1157
Page 1 of 34 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1