Search:

Tag: array

Page 1 of 35 1 2 3 4

Search: Replies Views Search took 0.01 seconds.

  1. Match between multiple values in single cells and lookup-list

    Started by cercig‎, 04-14-2021 08:42 AM
    array, match, vba & excel, vlookup 1 Attachment(s)
    • 89
    Last Post: 04-14-2021 10:38 AM
    by cercig  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  2. Baffled by mysterious mm/dd/yyyy date format

    Started by iwaddo‎, 04-11-2021 10:56 AM
    array, date, vba 1 Attachment(s)
    • 258
    Last Post: 04-13-2021 03:33 AM
    by iwaddo  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  3. [SOLVED] Auto populate values from raw data using multiple criteria

    Started by sabha‎, 03-26-2021 02:52 PM
    array, array formula, excel, excel 2007, excel formula 8 Attachment(s)
    • 183
    Last Post: 03-30-2021 01:28 PM
    by sabha  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Google Sheets Array Query

    Started by AncestryGuy‎, 03-25-2021 08:10 PM
    array, row, search, sheets
    • 164
    Last Post: 03-26-2021 06:24 AM
    by AncestryGuy  Go to last post

    Forum:
    For Other Platforms(Mac, Google Docs, Mobile OS etc)

  5. [SOLVED] Comparison of array for Matching and non matching values

    Started by chandramouliarun‎, 03-25-2021 04:04 AM
    array, array conditional, array formula 4 Attachment(s)
    • 144
    Last Post: 03-25-2021 06:48 AM
    by chandramouliarun  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] Creating a new list based on criteria in existing column (and map new columns to it)

    Started by MikeSTO‎, 03-17-2021 07:01 AM
    array, index match, list 2 Attachment(s)
    • 93
    Last Post: 03-17-2021 08:40 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Horizontal Index

    Started by excelman13‎, 03-17-2021 02:33 AM
    array, horizontal, index 1 Attachment(s)
    • 105
    Last Post: 03-17-2021 02:39 AM
    by alansidman  Go to last post

    Forum:
    Excel General

  8. Percentile Array Formula Limited to 25000 Rows?

    Started by EXCEL1BUR‎, 03-16-2021 10:55 AM
    array, percentile, percentile array
    • 219
    Last Post: 03-16-2021 12:41 PM
    by EXCEL1BUR  Go to last post

    Forum:
    Office 365

  9. INDEX-MATCH With 3 criteria

    Started by Sarah279‎, 03-08-2021 05:50 PM
    array, formula and functions, index, match & index 1 Attachment(s)
    • 117
    Last Post: 03-09-2021 02:58 AM
    by bebo021999  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Range to Array WITH Numberformat

    Started by Rezzy777‎, 03-08-2021 10:31 AM
    array, numberformat, range
    • 260
    Last Post: 03-09-2021 06:46 AM
    by Rezzy777  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  11. Correlating two range, need to adjust one range first

    Started by rykel02‎, 03-08-2021 05:00 AM
    add, array, correlate, number, ranges 1 Attachment(s)
    • 172
    Last Post: 03-15-2021 12:35 PM
    by rykel02  Go to last post

    Forum:
    Excel General

  12. [SOLVED] Getting array/index formula to ignore blank cells

    Started by LandSim‎, 03-03-2021 01:03 PM
    array, blank, blank cell, index 1 Attachment(s)
    • 125
    Last Post: 03-05-2021 02:29 PM
    by LandSim  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Scheduling: Always Evaluate a column range for Len>0 but with a changing column range

    Started by Tbenz‎, 01-30-2021 10:03 PM
    array, column, dynamic, formula, scheduling 4 Attachment(s)
    • 272
    Last Post: 02-01-2021 08:59 AM
    by Tbenz  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Spill/array formula to calculate average for specified ranges?

    Started by ErikBerger‎, 01-21-2021 05:07 AM
    array, average, spill 2 Attachment(s)
    • 349
    Last Post: 01-27-2021 07:22 AM
    by ErikBerger  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Array worksheetFunction.sum

    Started by olsonkyle12‎, 01-18-2021 12:25 PM
    array, currency, sum
    • 191
    Last Post: 01-20-2021 05:29 PM
    by olsonkyle12  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  16. Advice for Project - What to use: Dictionary, collection, array, reference workbook?

    Started by CSimm‎, 01-15-2021 10:35 AM
    array, automation, collection, dictionaries 1 Attachment(s)
    • 124
    Last Post: 01-15-2021 01:33 PM
    by mehmetcik  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. Array Formula to return column name if row contains "yes"

    Started by Tai1001‎, 01-11-2021 02:03 PM
    array 2 Attachment(s)
    • 130
    Last Post: 01-12-2021 06:02 AM
    by Tai1001  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] Named range into array using VBA - Subscript out of range

    Started by Pak Mariman‎, 12-31-2020 05:37 AM
    array, dim array, subscript out of range, vba
    • 266
    Last Post: 01-01-2021 06:31 AM
    by jindon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  19. sort an array

    Started by BetBoycie‎, 12-28-2020 12:03 PM
    array, sort 1 Attachment(s)
    • 347
    Last Post: 12-29-2020 05:24 PM
    by hrlngrv  Go to last post

    Forum:
    Excel Formulas & Functions

  20. How to select one row from each group of columns under a condition

    Started by JOAO12‎, 12-28-2020 10:24 AM
    array, duplicates in column, matrix, vba 2 Attachment(s)
    • 385
    Last Post: 01-02-2021 11:50 PM
    by JOAO12  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  21. Why Has My Formula Changed to an array formula?

    Started by jelarv‎, 12-24-2020 10:06 AM
    array, curly brackets, onedrive
    • 971
    Last Post: 12-24-2020 01:16 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel General

  22. [SOLVED] Compare an array in one file against contents of another file

    Started by TexARC‎, 12-16-2020 04:54 PM
    array, vlookup 3 Attachment(s)
    • 333
    Last Post: 12-20-2020 09:46 PM
    by TexARC  Go to last post

    Forum:
    Excel Formulas & Functions

  23. ArryLists for Multi-Column

    Started by UnloadMe‎, 12-16-2020 11:46 AM
    array, multi-column listbox
    • 284
    Last Post: 12-16-2020 10:02 PM
    by jindon  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  24. [SOLVED] Difference between two 2D Arrays

    Started by Pimo‎, 11-23-2020 09:09 PM
    array, array 2d, array duplicates, difference 2 Attachment(s)
    • 234
    Last Post: 11-24-2020 01:17 AM
    by Pimo  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  25. Shuffle this array, or else, fix my randomisation...

    Started by Darth269‎, 11-21-2020 07:56 AM
    array, random, vba 1 Attachment(s)
    • 250
    Last Post: 11-22-2020 02:36 AM
    by karedog  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  26. [SOLVED] Sumproduct logic array issue

    Started by 3foo3‎, 11-19-2020 04:02 PM
    array, excel, logic, sumif, sumproduct 3 Attachment(s)
    • 256
    Last Post: 11-19-2020 06:10 PM
    by 3foo3  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Arrays, Index, Match on multiple rows

    Started by nelsonk‎, 11-17-2020 10:56 AM
    array, index, match 2 Attachment(s)
    • 188
    Last Post: 11-17-2020 03:20 PM
    by nelsonk  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Returning a non-numerical value that matches another list

    Started by Peter Niklas‎, 11-15-2020 06:25 AM
    array, function, index, match 1 Attachment(s)
    • 143
    Last Post: 11-15-2020 06:52 AM
    by Phuocam  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] Creating an Array formula which calculates depending on what is filtered

    Started by Dandruce‎, 11-12-2020 05:37 AM
    aggregate, array, match and add, sum
    • 260
    Last Post: 11-16-2020 10:18 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  30. Excel 2016 Conditional Concatenate

    Started by JFawcett‎, 11-09-2020 11:47 AM
    array, concatenate, excel 2016 4 Attachment(s)
    • 240
    Last Post: 11-09-2020 01:25 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Print preview multiple sheets macro, based on cell value

    Started by umberto79‎, 10-29-2020 08:03 AM
    array, print multiple sheets
    • 161
    Last Post: 10-31-2020 04:01 PM
    by maniacb  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  32. Create array that skips cells

    Started by riedyp‎, 10-21-2020 02:22 PM
    array, index, match 1 Attachment(s)
    • 176
    Last Post: 10-22-2020 07:15 PM
    by Estevaoba  Go to last post

    Forum:
    Excel General

  33. Sum Distinct Values within Time Constraints?

    Started by tryhard‎, 10-21-2020 12:54 PM
    array, distinct values, duplicate controls, sumif, sumproduct 4 Attachment(s)
    • 218
    Last Post: 10-22-2020 12:01 PM
    by tryhard  Go to last post

    Forum:
    Excel General

  34. [SOLVED] Add Range/s to Array Based on CheckBox value being True

    Started by Andyw111‎, 10-14-2020 02:55 PM
    array, checkbox, range, userform, vba
    • 389
    Last Post: 10-16-2020 03:58 AM
    by Andyw111  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  35. Extract Data From Multiple Files

    Started by Frenzyy‎, 10-12-2020 09:57 AM
    array, extract, filename, filepath, lastrow
    • 283
    Last Post: 10-16-2020 04:40 AM
    by Frenzyy  Go to last post

    Forum:
    Excel Programming / VBA / Macros

Results 1 to 35 of 1212
Page 1 of 35 1 2 3 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1