Search Results - Excel Help Forum

Create array that skips cells

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

2

96

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

145

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

219

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

151

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

131

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

104

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

98

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

82

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

173

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

76

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

93

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

121

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

216

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

90

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

164

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

128

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

111

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

Forum:
Excel Formulas & Functions

[SOLVED] Is there a way to Set Desination with a variable?

Started by FanAnd22‎, 08-19-2020 10:58 AM

14

184

Last Post By:: Last Post: 08-20-2020 10:41 AM; by FanAnd22

Forum:
Excel Programming / VBA / Macros

Dynamic data that is updated on a worksheet, can it be captured and made into an array?

Started by jderosa3‎, 08-17-2020 08:48 PM

5

160

Last Post By:: Last Post: 08-18-2020 04:05 PM; by vba_php

Forum:
Excel Programming / VBA / Macros

[SOLVED] Dynamic table header replicating max no. of occurrences per row across table, sorted

Started by Marbleking‎, 08-16-2020 07:23 AM

17

300

Last Post By:: Last Post: 08-17-2020 02:26 AM; by XOR LX

Forum:
Excel Formulas & Functions

[SOLVED] Getting a vertical array containing the maximum values from each row of a 2D matrix

Started by Marbleking‎, 08-14-2020 02:41 PM

10

217

Last Post By:: Last Post: 08-15-2020 12:19 PM; by Bo_Ry

Forum:
Excel Formulas & Functions

Excel Index Match with date and multiple criteria returning #N/A

Started by CC11‎, 07-30-2020 08:03 PM

2

130

Last Post By:: Last Post: 07-31-2020 01:08 AM; by CC11

Forum:
Excel Formulas & Functions

[SOLVED] Obtain value in first column of table with multiple criteria

Started by GeorgeP18‎, 07-24-2020 04:27 PM

4

755

Last Post By:: Last Post: 07-25-2020 03:35 AM; by oeldere

Forum:
Excel General

[SOLVED] Dynamic array will not pass through to the 'TotalList' parameter in my subtotal routine

Started by James McEwan‎, 07-22-2020 11:33 AM

array, for ... each loops, subtotal, vba

3

87

Last Post By:: Last Post: 07-22-2020 12:29 PM; by CK76

Forum:
Excel Programming / VBA / Macros

[SOLVED] Index match with multiple criteria

Started by Marbleking‎, 07-09-2020 07:19 PM

2

154

Last Post By:: Last Post: 07-10-2020 07:37 AM; by Marbleking

Forum:
Excel Formulas & Functions

Juxtaposing successive levels from parent-child relational data

Started by Marbleking‎, 07-01-2020 04:35 PM

array, hierarchical structure, parent child, relational database

22

577

Last Post By:: Last Post: 07-08-2020 11:41 PM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Excel Table lookup Named Range

Started by revocats10‎, 06-27-2020 05:16 AM

array, excel named ranges, table, vlookup

7

138

Last Post By:: Last Post: 06-27-2020 06:55 AM; by AliGW

Forum:
Excel Formulas & Functions

Create Singular record from a Zip Code Range table

Started by zoso333‎, 06-23-2020 08:07 AM

2

128

Last Post By:: Last Post: 06-23-2020 09:33 AM; by zoso333

Forum:
Excel Programming / VBA / Macros

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

Started by Lance15‎, 06-16-2020 09:22 PM

7

712

Last Post By:: Last Post: 07-04-2020 12:59 AM; by nisarga

Forum:
Excel Programming / VBA / Macros

[SOLVED] Multiple IF conditions in ARRAY formula

Started by pritesh118‎, 06-16-2020 01:41 PM

array, multiple and, multiple if, multiple or

4

136

Last Post By:: Last Post: 06-17-2020 07:59 AM; by Fluff13

Forum:
Excel Formulas & Functions

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

Started by DexterStagg‎, 06-13-2020 01:12 PM

2

155

Last Post By:: Last Post: 06-14-2020 10:42 AM; by Gregb11

Forum:
Excel Formulas & Functions

If value is in array then copy row to another sheet

Started by DanzaNZ‎, 06-10-2020 01:54 AM

2

148

Last Post By:: Last Post: 06-10-2020 07:56 PM; by DanzaNZ

Forum:
Excel Programming / VBA / Macros

Array formula data limits

Started by Eelman‎, 06-07-2020 07:26 PM

1

127

Last Post By:: Last Post: 06-07-2020 09:13 PM; by bebo021999

Forum:
Excel Formulas & Functions

=SUM(countifs with two set of multiple data

Started by ciaron178‎, 06-04-2020 11:59 AM

array, counifs, countifs or, formula, sum

4

129

Last Post By:: Last Post: 06-04-2020 03:42 PM; by XOR LX

Forum:
Excel Formulas & Functions

[SOLVED] Auto Categorize Products

Started by Gidion‎, 06-04-2020 07:35 AM

8

149

Last Post By:: Last Post: 06-04-2020 10:23 AM; by Gidion

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

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

[SOLVED] Is there a way to Set Desination with a variable?

Dynamic data that is updated on a worksheet, can it be captured and made into an array?

[SOLVED] Dynamic table header replicating max no. of occurrences per row across table, sorted

[SOLVED] Getting a vertical array containing the maximum values from each row of a 2D matrix

Excel Index Match with date and multiple criteria returning #N/A

[SOLVED] Obtain value in first column of table with multiple criteria

[SOLVED] Dynamic array will not pass through to the 'TotalList' parameter in my subtotal routine

[SOLVED] Index match with multiple criteria

Juxtaposing successive levels from parent-child relational data

[SOLVED] Excel Table lookup Named Range

Create Singular record from a Zip Code Range table

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

[SOLVED] Multiple IF conditions in ARRAY formula

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

If value is in array then copy row to another sheet

Array formula data limits

=SUM(countifs with two set of multiple data

[SOLVED] Auto Categorize Products