array - Search Results - Excel Help Forum

Spill/array formula to calculate average for specified ranges?

Started by ErikBerger‎, Yesterday 05:07 AM

4

101

Last Post By:: Last Post: Yesterday 10:24 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

Array worksheetFunction.sum

Started by olsonkyle12‎, 01-18-2021 12:25 PM

2

142

Last Post By:: Last Post: 01-20-2021 05:29 PM; by olsonkyle12

Forum:
Excel Programming / VBA / Macros

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

84

Last Post By:: Last Post: 01-15-2021 01:33 PM; by mehmetcik

Forum:
Excel Programming / VBA / Macros

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

Started by Tai1001‎, 01-11-2021 02:03 PM

2

102

Last Post By:: Last Post: 01-12-2021 06:02 AM; by Tai1001

Forum:
Excel Formulas & Functions

[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

6

222

Last Post By:: Last Post: 01-01-2021 06:31 AM; by jindon

Forum:
Excel Programming / VBA / Macros

sort an array

Started by BetBoycie‎, 12-28-2020 12:03 PM

19

296

Last Post By:: Last Post: 12-29-2020 05:24 PM; by hrlngrv

Forum:
Excel Formulas & Functions

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

5

257

Last Post By:: Last Post: 01-02-2021 11:50 PM; by JOAO12

Forum:
Excel Programming / VBA / Macros

Why Has My Formula Changed to an array formula?

Started by jelarv‎, 12-24-2020 10:06 AM

5

935

Last Post By:: Last Post: 12-24-2020 01:16 PM; by 6StringJazzer

Forum:
Excel General

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

Started by TexARC‎, 12-16-2020 04:54 PM

16

280

Last Post By:: Last Post: 12-20-2020 09:46 PM; by TexARC

Forum:
Excel Formulas & Functions

ArryLists for Multi-Column

Started by UnloadMe‎, 12-16-2020 11:46 AM

10

202

Last Post By:: Last Post: 12-16-2020 10:02 PM; by jindon

Forum:
Excel Programming / VBA / Macros

[SOLVED] Difference between two 2D Arrays

Started by Pimo‎, 11-23-2020 09:09 PM

array, array 2d, array duplicates, difference

7

188

Last Post By:: Last Post: 11-24-2020 01:17 AM; by Pimo

Forum:
Excel Programming / VBA / Macros

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

Started by Darth269‎, 11-21-2020 07:56 AM

8

214

Last Post By:: Last Post: 11-22-2020 02:36 AM; by karedog

Forum:
Excel Programming / VBA / Macros

[SOLVED] Sumproduct logic array issue

Started by 3foo3‎, 11-19-2020 04:02 PM

14

208

Last Post By:: Last Post: 11-19-2020 06:10 PM; by 3foo3

Forum:
Excel Formulas & Functions

Arrays, Index, Match on multiple rows

Started by nelsonk‎, 11-17-2020 10:56 AM

3

142

Last Post By:: Last Post: 11-17-2020 03:20 PM; by nelsonk

Forum:
Excel Formulas & Functions

Returning a non-numerical value that matches another list

Started by Peter Niklas‎, 11-15-2020 06:25 AM

2

104

Last Post By:: Last Post: 11-15-2020 06:52 AM; by Phuocam

Forum:
Excel Formulas & Functions

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

Started by Dandruce‎, 11-12-2020 05:37 AM

5

216

Last Post By:: Last Post: 11-16-2020 10:18 AM; by JeteMc

Forum:
Excel General

Excel 2016 Conditional Concatenate

Started by JFawcett‎, 11-09-2020 11:47 AM

11

181

Last Post By:: Last Post: 11-09-2020 01:25 PM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

Print preview multiple sheets macro, based on cell value

Started by umberto79‎, 10-29-2020 08:03 AM

1

133

Last Post By:: Last Post: 10-31-2020 04:01 PM; by maniacb

Forum:
Excel Programming / VBA / Macros

Create array that skips cells

Started by riedyp‎, 10-21-2020 02:22 PM

2

136

Last Post By:: Last Post: 10-22-2020 07:15 PM; by Estevaoba

Forum:
Excel General

Sum Distinct Values within Time Constraints?

Started by tryhard‎, 10-21-2020 12:54 PM

array, distinct values, duplicate controls, sumif, sumproduct

6

178

Last Post By:: Last Post: 10-22-2020 12:01 PM; by tryhard

Forum:
Excel General

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

Started by Andyw111‎, 10-14-2020 02:55 PM

11

305

Last Post By:: Last Post: 10-16-2020 03:58 AM; by Andyw111

Forum:
Excel Programming / VBA / Macros

Extract Data From Multiple Files

Started by Frenzyy‎, 10-12-2020 09:57 AM

array, extract, filename, filepath, lastrow

3

212

Last Post By:: Last Post: 10-16-2020 04:40 AM; by Frenzyy

Forum:
Excel Programming / VBA / Macros

Struggling with a Lookup Problem

Started by clairefromperth‎, 10-01-2020 11:39 AM

5

168

Last Post By:: Last Post: 10-01-2020 10:45 PM; by Gregb11

Forum:
Excel Formulas & Functions

[SOLVED] Sort array into ascending order - place special strings as first elements

Started by Un-Do Re-Do‎, 09-30-2020 01:27 AM

2

132

Last Post By:: Last Post: 09-30-2020 02:00 AM; by Un-Do Re-Do

Forum:
Excel Programming / VBA / Macros

[SOLVED] Delete cells not in array

Started by Un-Do Re-Do‎, 09-28-2020 12:16 AM

4

125

Last Post By:: Last Post: 09-28-2020 03:08 AM; by Un-Do Re-Do

Forum:
Excel Programming / VBA / Macros

How to turn columns of data into a table

Started by CYCBurner‎, 09-23-2020 11:54 AM

array, macro, organizing data, table, vba

2

110

Last Post By:: Last Post: 09-23-2020 12:09 PM; by AlphaFrog

Forum:
Excel Programming / VBA / Macros

[SOLVED] Array formula needs a condition added to it

Started by ReturningHack‎, 09-22-2020 07:15 PM

11

210

Last Post By:: Last Post: 09-23-2020 10:19 AM; by ReturningHack

Forum:
Excel Formulas & Functions

[SOLVED] Store border information in arrays

Started by Un-Do Re-Do‎, 09-18-2020 04:13 AM

2

101

Last Post By:: Last Post: 09-18-2020 07:13 AM; by Un-Do Re-Do

Forum:
Excel Programming / VBA / Macros

[SOLVED] Array for borders

Started by Un-Do Re-Do‎, 09-17-2020 11:13 PM

2

125

Last Post By:: Last Post: 09-18-2020 02:07 AM; by Un-Do Re-Do

Forum:
Excel Programming / VBA / Macros

Need to sum all rows in a SUMPRODUCT nested array when condition cell is blank

Started by regnile‎, 09-11-2020 07:17 PM

2

146

Last Post By:: Last Post: 09-16-2020 01:33 PM; by regnile

Forum:
Excel Formulas & Functions

extract an element out of a single-cell array

Started by mfragugl‎, 09-08-2020 06:49 PM

4

258

Last Post By:: Last Post: 09-10-2020 09:17 AM; by MrShorty

Forum:
Excel Formulas & Functions

Extracting Data from a List

Started by djc123‎, 08-31-2020 06:08 AM

1

115

Last Post By:: Last Post: 08-31-2020 07:09 AM; by CARACALLA

Forum:
Excel Formulas & Functions

going a step beyond index-match function

Started by chemicalnerd37‎, 08-27-2020 09:17 AM

6

197

Last Post By:: Last Post: 08-28-2020 03:29 AM; by bebo021999

Forum:
Excel Formulas & Functions

A leaderboard but with multiple entries

Started by kraser‎, 08-26-2020 06:03 PM

1

151

Last Post By:: Last Post: 08-31-2020 10:48 AM; by JeteMc

Forum:
Excel Formulas & Functions

Lookup of array values

Started by jlp1981‎, 08-21-2020 06:43 AM

4

139

Last Post By:: Last Post: 08-21-2020 12:51 PM; by jlp1981

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

Spill/array formula to calculate average for specified ranges?

Array worksheetFunction.sum

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

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

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

sort an array

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

Why Has My Formula Changed to an array formula?

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

ArryLists for Multi-Column

[SOLVED] Difference between two 2D Arrays

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

[SOLVED] Sumproduct logic array issue

Arrays, Index, Match on multiple rows

Returning a non-numerical value that matches another list

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

Excel 2016 Conditional Concatenate

Print preview multiple sheets macro, based on cell value

Create array that skips cells

Sum Distinct Values within Time Constraints?

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

Extract Data From Multiple Files

Struggling with a Lookup Problem

[SOLVED] Sort array into ascending order - place special strings as first elements

[SOLVED] Delete cells not in array

How to turn columns of data into a table

[SOLVED] Array formula needs a condition added to it

[SOLVED] Store border information in arrays

[SOLVED] Array for borders

Need to sum all rows in a SUMPRODUCT nested array when condition cell is blank

extract an element out of a single-cell array

Extracting Data from a List

going a step beyond index-match function

A leaderboard but with multiple entries

Lookup of array values