array - Search Results - Excel Help Forum

Remove rows with empty cells depending on multiple columns

Started by SidLeBricoleur‎, Today 03:30 PM

array, removeduplicates, sort & edit, table, vba

1

44

Last Post By:: Last Post: Today 05:46 PM; by WideBoyDixon

Forum:
Excel Programming / VBA / Macros

[SOLVED] Lookup that returns vertical array in horizontal format

Started by chanelinyavapai‎, 01-24-2022 02:32 PM

6

102

Last Post By:: Last Post: 01-25-2022 10:50 AM; by Fluff13

Forum:
Excel Formulas & Functions

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

Started by mp3lab‎, 01-20-2022 01:58 PM

15

223

Last Post By:: Last Post: 01-22-2022 09:16 AM; by Glenn Kennedy

Forum:
Excel General

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

Started by immigrated4urjob‎, 01-20-2022 11:51 AM

3

79

Last Post By:: Last Post: 01-20-2022 12:00 PM; by rorya

Forum:
Excel Programming / VBA / Macros

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

Started by Merf‎, 01-17-2022 05:36 PM

3

100

Last Post By:: Last Post: 01-18-2022 09:33 PM; by JeteMc

Forum:
Excel Formulas & Functions

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

Started by hic24‎, 01-15-2022 05:46 PM

array, listobject, powerprogrammingwithvba, table

3

70

Last Post By:: Last Post: 01-15-2022 06:00 PM; by Fluff13

Forum:
Excel Programming / VBA / Macros

Check if Word Exists in Array?

Started by Merf‎, 01-14-2022 04:11 PM

13

159

Last Post By:: Last Post: 01-14-2022 05:25 PM; by JEC.

Forum:
Excel Programming / VBA / Macros

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

Started by chandramouliarun‎, 01-11-2022 06:14 AM

3

93

Last Post By:: Last Post: 01-11-2022 12:20 PM; by KOKOSEK

Forum:
Excel Formulas & Functions

Unique values from array then average adjacent column values

Started by tomisthereason‎, 12-24-2021 08:18 AM

8

128

Last Post By:: Last Post: 12-24-2021 09:12 AM; by tomisthereason

Forum:
Excel Formulas & Functions

SUM(IF( Array Produces Zero

Started by rbellotti‎, 12-14-2021 08:08 PM

18

274

Last Post By:: Last Post: 12-16-2021 03:38 AM; by wk9128

Forum:
Excel Formulas & Functions

Using a named range ARRAY inside an OFFSET function

Started by James McEwan‎, 11-22-2021 02:49 PM

2

158

Last Post By:: Last Post: 11-22-2021 03:36 PM; by James McEwan

Forum:
Excel Formulas & Functions

Invalid Qualifier in very basic VBA array code

Started by pou2010‎, 11-21-2021 11:27 AM

1

164

Last Post By:: Last Post: 11-21-2021 03:04 PM; by rorya

Forum:
Excel Programming / VBA / Macros

[SOLVED] Creating an ARRAY from non-sequential periods

Started by James McEwan‎, 11-20-2021 01:33 PM

1

177

Last Post By:: Last Post: 11-21-2021 03:24 AM; by shank_mis

Forum:
Excel Formulas & Functions

[SOLVED] Turn a COUNT formula into a Spilled Array formula

Started by sire152003‎, 11-18-2021 07:13 PM

11

207

Last Post By:: Last Post: 11-19-2021 06:38 AM; by sire152003

Forum:
Excel Formulas & Functions

[SOLVED] RETURN FVSCHEDULE as a SPILL ARRAY

Started by James McEwan‎, 11-18-2021 10:55 AM

array, future value, fvschedule, present value

2

165

Last Post By:: Last Post: 11-20-2021 01:22 PM; by James McEwan

Forum:
Excel Formulas & Functions

[SOLVED] Return SUM of values as an ARRAY

Started by James McEwan‎, 11-18-2021 10:02 AM

6

152

Last Post By:: Last Post: 11-18-2021 11:31 AM; by James McEwan

Forum:
Excel Formulas & Functions

TEXTJOIN and IF Array

Started by mrmacs‎, 11-12-2021 08:34 AM

1

93

Last Post By:: Last Post: 11-12-2021 08:51 AM; by AliGW

Forum:
Excel Formulas & Functions

Solved: Sum values associated with keywords inside cell

Started by witchcraftz‎, 11-09-2021 10:43 PM

4

209

Last Post By:: Last Post: 11-17-2021 04:35 PM; by witchcraftz

Forum:
Excel Formulas & Functions

How to generate arrays name using concat or similar functions

Started by nima50‎, 11-09-2021 09:34 PM

5

160

Last Post By:: Last Post: 11-10-2021 07:18 AM; by DJunqueira

Forum:
Excel Formulas & Functions

Faster Alternative to Sumifs?

Started by jakegordon97‎, 11-09-2021 04:01 PM

4

136

Last Post By:: Last Post: 11-09-2021 05:45 PM; by TMS

Forum:
Excel Formulas & Functions

[SOLVED] Need array formulas for Countif that counts row by row and an array Mod formula

Started by Slickback724‎, 11-05-2021 10:56 AM

4

345

Last Post By:: Last Post: 11-09-2021 12:38 AM; by janmorris

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

[SOLVED] List using curly brackets (braces) in formula to create a list

Started by Dicken‎, 10-31-2021 12:28 PM

2

239

Last Post By:: Last Post: 10-31-2021 01:19 PM; by Fluff13

Forum:
Excel General

[SOLVED] Need help with data transfer coding (Data array included)

Started by alexlim258‎, 10-28-2021 07:19 AM

2

330

Last Post By:: Last Post: 10-28-2021 10:44 AM; by alexlim258

Forum:
Excel Programming / VBA / Macros

Arranging a table of raw data in ascending order

Started by qejo‎, 10-22-2021 05:59 AM

arrange raw data, array, ascending, sort, values

4

170

Last Post By:: Last Post: 10-22-2021 06:52 AM; by diamondgeezer1974

Forum:
Excel General

How to Merge two arrays with filter condition?

Started by petedebruy‎, 10-18-2021 07:17 AM

1

128

Last Post By:: Last Post: 10-18-2021 07:33 AM; by bsalv

Forum:
Excel Programming / VBA / Macros

[SOLVED] Extract specific elements from 2d array and add to new 2d array

Started by kosherboy‎, 10-12-2021 03:56 PM

10

269

Last Post By:: Last Post: 10-13-2021 12:32 AM; by Akuini

Forum:
Excel Programming / VBA / Macros

[SOLVED] Transposing a vertical list automatically after pasting it in a column?

Started by rcane‎, 10-04-2021 02:50 PM

15

333

Last Post By:: Last Post: 10-09-2021 11:54 AM; by rcane

Forum:
Excel Formulas & Functions

[SOLVED] Automatically fill summary table with filtered data based on drop-down list

Started by ummi21‎, 10-04-2021 09:54 AM

array, formula, function, index & match, vlookup

7

166

Last Post By:: Last Post: 10-04-2021 10:26 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] How to count the number of times an item in ColB appears in ColA.

Started by rcane‎, 09-29-2021 09:38 AM

3

144

Last Post By:: Last Post: 09-30-2021 12:29 PM; by rcane

Forum:
Excel Formulas & Functions

Array that returns multiple results matching a date

Started by am.annunz‎, 09-21-2021 11:38 AM

1

146

Last Post By:: Last Post: 09-21-2021 02:51 PM; by JohnTopley

Forum:
Excel Formulas & Functions

SumIF + Large + Array in Google Sheets

Started by cbhirn‎, 09-13-2021 03:55 PM

array, google sheet, google sheets, large, sumif

1

277

Last Post By:: Last Post: 09-14-2021 08:10 PM; by janmorris

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

Array formulate with multiple criteria without duplicates

Started by mvictor93‎, 09-07-2021 12:13 PM

3

198

Last Post By:: Last Post: 09-07-2021 10:37 PM; by mvictor93

Forum:
Excel Formulas & Functions

[SOLVED] Need formula to find which column has the highest Total

Started by JV0710‎, 08-30-2021 07:02 AM

6

185

Last Post By:: Last Post: 08-30-2021 08:28 AM; by wk9128

Forum:
Excel Formulas & Functions

Which column has the highest Total

Started by JV0710‎, 08-30-2021 06:17 AM

1

164

Last Post By:: Last Post: 08-30-2021 08:12 AM; by wk9128

Forum:
Excel General

[SOLVED] Checkbox to edit specific sheets when macro is run

Started by rose8693‎, 08-19-2021 08:16 AM

1

188

Last Post By:: Last Post: 08-19-2021 05:01 PM; by NoSparks

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.01 seconds; generated 5 minute(s) ago.

Remove rows with empty cells depending on multiple columns

[SOLVED] Lookup that returns vertical array in horizontal format

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

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

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

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

Check if Word Exists in Array?

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

Unique values from array then average adjacent column values

SUM(IF( Array Produces Zero

Using a named range ARRAY inside an OFFSET function

Invalid Qualifier in very basic VBA array code

[SOLVED] Creating an ARRAY from non-sequential periods

[SOLVED] Turn a COUNT formula into a Spilled Array formula

[SOLVED] RETURN FVSCHEDULE as a SPILL ARRAY

[SOLVED] Return SUM of values as an ARRAY

TEXTJOIN and IF Array

Solved: Sum values associated with keywords inside cell

How to generate arrays name using concat or similar functions

Faster Alternative to Sumifs?

[SOLVED] Need array formulas for Countif that counts row by row and an array Mod formula

[SOLVED] List using curly brackets (braces) in formula to create a list

[SOLVED] Need help with data transfer coding (Data array included)

Arranging a table of raw data in ascending order

How to Merge two arrays with filter condition?

[SOLVED] Extract specific elements from 2d array and add to new 2d array

[SOLVED] Transposing a vertical list automatically after pasting it in a column?

[SOLVED] Automatically fill summary table with filtered data based on drop-down list

[SOLVED] How to count the number of times an item in ColB appears in ColA.

Array that returns multiple results matching a date

SumIF + Large + Array in Google Sheets

Array formulate with multiple criteria without duplicates

[SOLVED] Need formula to find which column has the highest Total

Which column has the highest Total

[SOLVED] Checkbox to edit specific sheets when macro is run