Search:

Tag: array

Page 1 of 37 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. Remove zero values from Transpose function

    Started by jw2022‎, 07-04-2022 05:22 AM
    array, data validation, formula, tranpose, zero as blank
    • 103
    Last Post: 07-04-2022 09:19 PM
    by jw2022  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Find value in a table based on two inputs

    Started by comedygliss‎, 06-23-2022 11:14 AM
    array, return a value, table, two variables 1 Attachment(s)
    • 64
    Last Post: 06-23-2022 11:19 AM
    by Fluff13  Go to last post

    Forum:
    Excel General

  3. Find and list all instances of a value and associated column

    Started by alo2279‎, 06-06-2022 03:17 PM
    array, index, multiple values 1 Attachment(s)
    • 106
    Last Post: 06-15-2022 12:36 PM
    by alo2279  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Combining arrays every other rows

    Started by qsdfghjklm45‎, 05-23-2022 06:03 AM
    array 2 Attachment(s)
    • 130
    Last Post: 05-23-2022 06:22 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  5. [SOLVED] Moving an array formula to VBA only, with memory?

    Started by Tree310‎, 05-20-2022 07:03 AM
    array, automatically change, remember cell value, two books, vba
    • 111
    Last Post: 05-20-2022 05:21 PM
    by Tree310  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  6. Index/Match formula returning only prioritised results

    Started by Whatsyerpoison1‎, 05-18-2022 10:54 AM
    array, formula, index, match, sort
    • 83
    Last Post: 05-18-2022 11:03 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Generating random array with conditions

    Started by kohno71‎, 05-18-2022 01:57 AM
    array, constraints, dynamic array formula, random, variable 2 Attachment(s)
    • 181
    Last Post: 05-18-2022 09:17 AM
    by kohno71  Go to last post

    Forum:
    Excel Formulas & Functions

  8. How can I cycle through range, and extract text from rows, if rows contain specific text?

    Started by eduardb96‎, 05-17-2022 02:58 PM
    array, extract characters, formula 3 Attachment(s)
    • 218
    Last Post: 05-18-2022 10:13 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Building Arrays without a sequence

    Started by jphen‎, 05-16-2022 09:37 AM
    array, excel, index, sequence
    • 145
    Last Post: 05-16-2022 11:22 AM
    by WideBoyDixon  Go to last post

    Forum:
    Excel General

  10. [SOLVED] ARRAYTOTEXT for multiple columns?

    Started by ellieholmes‎, 05-03-2022 08:46 AM
    array, table to list 1 Attachment(s)
    • 139
    Last Post: 05-03-2022 09:46 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  11. WorksheetFunction.Sort Pre-pending a Null Value to an Array

    Started by wiitguru‎, 04-25-2022 05:50 PM
    array, sort, vba & excel, worksheetfunction
    • 178
    Last Post: 04-27-2022 07:13 PM
    by wiitguru  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  12. [SOLVED] Want to Remove Values from an Array

    Started by TGA123‎, 04-22-2022 09:39 AM
    array, formula, help a dummy, how to, remove 2 Attachment(s)
    • 355
    Last Post: 04-23-2022 09:00 AM
    by nick.williams  Go to last post

    Forum:
    Excel General

  13. Adjusting textbox to filter listbox for 1D array

    Started by immigrated4urjob‎, 03-31-2022 02:48 PM
    array
    • 101
    Last Post: 03-31-2022 02:48 PM
    by immigrated4urjob  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  14. How can avoid .copy and .paste in this loop?

    Started by carlmon‎, 03-30-2022 07:59 AM
    array, foreach, redim 1 Attachment(s)
    • 170
    Last Post: 03-31-2022 07:53 AM
    by carlmon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  15. [SOLVED] Array of cell row numbers based on first occurrences

    Started by sonyxmase‎, 03-28-2022 12:32 AM
    array, first occurrence, rows 3 Attachment(s)
    • 190
    Last Post: 03-28-2022 11:04 AM
    by nick.williams  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] XIRR with Non-Contiguous Values and Dates?

    Started by Merf‎, 03-25-2022 09:47 AM
    array, non contiguous range
    • 210
    Last Post: 03-26-2022 10:09 AM
    by Merf  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] Return Multiple Records if criteria met

    Started by KerahJoy‎, 03-18-2022 09:48 PM
    array, criteria, formula, return 2 Attachment(s)
    • 189
    Last Post: 03-22-2022 07:14 PM
    by wk9128  Go to last post

    Forum:
    Excel General

  18. [SOLVED] Array Formula in place of vlookup?

    Started by Barking_Mad‎, 03-15-2022 06:17 AM
    array, vlookup 3 Attachment(s)
    • 321
    Last Post: 03-15-2022 08:37 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] VBA find and replace using arrays

    Started by cNorth‎, 03-14-2022 05:34 AM
    array, find and replace, vba
    • 177
    Last Post: 03-14-2022 06:51 PM
    by macropod  Go to last post

    Forum:
    Word Programming / VBA / Macros

  20. What is str value in this simple code?

    Started by immigrated4urjob‎, 03-11-2022 12:36 PM
    array
    • 105
    Last Post: 03-11-2022 01:49 PM
    by rorya  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  21. Index list values that meet criteria

    Started by JyothiGrace‎, 03-02-2022 12:15 PM
    array, concise list, index, num error 2 Attachment(s)
    • 107
    Last Post: 03-02-2022 12:23 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  22. Dependent Array doesn't drop down after loading

    Started by Qidpemberton‎, 02-28-2022 12:16 PM
    array 1 Attachment(s)
    • 148
    Last Post: 02-28-2022 12:47 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Sum total of all cells between 2 HLOOKUP points

    Started by jstn‎, 02-25-2022 04:50 PM
    array, hlookup, sum 1 Attachment(s)
    • 176
    Last Post: 02-25-2022 05:54 PM
    by jstn  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Remove rows with empty cells depending on multiple columns

    Started by SidLeBricoleur‎, 01-27-2022 03:30 PM
    array, removeduplicates, sort & edit, table, vba 1 Attachment(s)
    • 200
    Last Post: 01-28-2022 06:00 PM
    by maniacb  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  25. [SOLVED] Lookup that returns vertical array in horizontal format

    Started by chanelinyavapai‎, 01-24-2022 02:32 PM
    array, index, xlookup 1 Attachment(s)
    • 236
    Last Post: 01-25-2022 10:50 AM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] EXCEL to return first cell value if a match is found in an array

    Started by mp3lab‎, 01-20-2022 01:58 PM
    array, excel, filter 4 Attachment(s)
    • 392
    Last Post: 01-22-2022 09:16 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  27. myArray() failing with cell method and works with Variant type only

    Started by immigrated4urjob‎, 01-20-2022 11:51 AM
    array 1 Attachment(s)
    • 172
    Last Post: 01-20-2022 12:00 PM
    by rorya  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  28. [SOLVED] IRR from table of Mixed (monthly) Returns?

    Started by Merf‎, 01-17-2022 05:36 PM
    array, irr, xirr 2 Attachment(s)
    • 217
    Last Post: 01-18-2022 09:33 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] Transfer ListObject to Array ---> array subscripts default to base 1?

    Started by hic24‎, 01-15-2022 05:46 PM
    array, listobject, powerprogrammingwithvba, table
    • 164
    Last Post: 01-15-2022 06:00 PM
    by Fluff13  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  30. Check if Word Exists in Array?

    Started by Merf‎, 01-14-2022 04:11 PM
    array, error #5, match, runtime error 5 3 Attachment(s)
    • 272
    Last Post: 01-14-2022 05:25 PM
    by JEC.  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  31. [SOLVED] Help with Excel Formula to get the intersecting codes

    Started by chandramouliarun‎, 01-11-2022 06:14 AM
    array, excel & formula 2 Attachment(s)
    • 189
    Last Post: 01-11-2022 12:20 PM
    by KOKOSEK  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Unique values from array then average adjacent column values

    Started by tomisthereason‎, 12-24-2021 08:18 AM
    array, average, formula, multiple 1 Attachment(s)
    • 280
    Last Post: 12-24-2021 09:12 AM
    by tomisthereason  Go to last post

    Forum:
    Excel Formulas & Functions

  33. SUM(IF( Array Produces Zero

    Started by rbellotti‎, 12-14-2021 08:08 PM
    array, sum(if( 3 Attachment(s)
    • 411
    Last Post: 12-16-2021 03:38 AM
    by wk9128  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Using a named range ARRAY inside an OFFSET function

    Started by James McEwan‎, 11-22-2021 02:49 PM
    array, named range, offset, sequence 2 Attachment(s)
    • 239
    Last Post: 11-22-2021 03:36 PM
    by James McEwan  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Invalid Qualifier in very basic VBA array code

    Started by pou2010‎, 11-21-2021 11:27 AM
    array, invalid qualifier
    • 264
    Last Post: 11-21-2021 03:04 PM
    by rorya  Go to last post

    Forum:
    Excel Programming / VBA / Macros

Results 1 to 35 of 1288
Page 1 of 37 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1