array - Search Results - Excel Help Forum

Building Arrays without a sequence

Started by jphen‎, 05-16-2022 09:37 AM

3

413

Last Post By:: Last Post: 05-16-2022 11:22 AM; by WideBoyDixon

Forum:
Excel General

[SOLVED] ARRAYTOTEXT for multiple columns?

Started by ellieholmes‎, 05-03-2022 08:46 AM

6

326

Last Post By:: Last Post: 05-03-2022 09:46 AM; by Fluff13

Forum:
Excel Formulas & Functions

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

Started by wiitguru‎, 04-25-2022 05:50 PM

array, sort, vba & excel, worksheetfunction

7

696

Last Post By:: Last Post: 04-27-2022 07:13 PM; by wiitguru

Forum:
Excel Programming / VBA / Macros

[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

18

6,582

Last Post By:: Last Post: 04-23-2022 09:00 AM; by nick.williams

Forum:
Excel General

Adjusting textbox to filter listbox for 1D array

Started by immigrated4urjob‎, 03-31-2022 02:48 PM

0

232

Last Post By:: Last Post: 03-31-2022 02:48 PM; by immigrated4urjob

Forum:
Excel Programming / VBA / Macros

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

Started by carlmon‎, 03-30-2022 07:59 AM

7

336

Last Post By:: Last Post: 03-31-2022 07:53 AM; by carlmon

Forum:
Excel Programming / VBA / Macros

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

Started by sonyxmase‎, 03-28-2022 12:32 AM

7

413

Last Post By:: Last Post: 03-28-2022 11:04 AM; by nick.williams

Forum:
Excel Formulas & Functions

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

Started by Merf‎, 03-25-2022 09:47 AM

9

1,122

Last Post By:: Last Post: 03-26-2022 10:09 AM; by Merf

Forum:
Excel Formulas & Functions

[SOLVED] Return Multiple Records if criteria met

Started by KerahJoy‎, 03-18-2022 09:48 PM

4

453

Last Post By:: Last Post: 03-22-2022 07:14 PM; by wk9128

Forum:
Excel General

[SOLVED] Array Formula in place of vlookup?

Started by Barking_Mad‎, 03-15-2022 06:17 AM

25

570

Last Post By:: Last Post: 03-15-2022 08:37 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] VBA find and replace using arrays

Started by cNorth‎, 03-14-2022 05:34 AM

3

922

Last Post By:: Last Post: 03-14-2022 06:51 PM; by macropod

Forum:
Word Programming / VBA / Macros

What is str value in this simple code?

Started by immigrated4urjob‎, 03-11-2022 12:36 PM

3

236

Last Post By:: Last Post: 03-11-2022 01:49 PM; by rorya

Forum:
Excel Programming / VBA / Macros

Index list values that meet criteria

Started by JyothiGrace‎, 03-02-2022 12:15 PM

1

283

Last Post By:: Last Post: 03-02-2022 12:23 PM; by Glenn Kennedy

Forum:
Excel General

Dependent Array doesn't drop down after loading

Started by Qidpemberton‎, 02-28-2022 12:16 PM

8

300

Last Post By:: Last Post: 02-28-2022 12:47 PM; by Fluff13

Forum:
Excel Formulas & Functions

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

Started by jstn‎, 02-25-2022 04:50 PM

7

925

Last Post By:: Last Post: 02-25-2022 05:54 PM; by jstn

Forum:
Excel Formulas & Functions

[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

3

355

Last Post By:: Last Post: 01-28-2022 06:00 PM; by maniacb

Forum:
Excel Programming / VBA / Macros

[SOLVED] Lookup that returns vertical array in horizontal format

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

6

691

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

737

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

306

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

359

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

344

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

621

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

310

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

531

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

579

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

429

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

510

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

700

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

583

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

379

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

353

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

308

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

450

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

329

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

1,920

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

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds.

Building Arrays without a sequence

[SOLVED] ARRAYTOTEXT for multiple columns?

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

[SOLVED] Want to Remove Values from an Array

Adjusting textbox to filter listbox for 1D array

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

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

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

[SOLVED] Return Multiple Records if criteria met

[SOLVED] Array Formula in place of vlookup?

[SOLVED] VBA find and replace using arrays

What is str value in this simple code?

Index list values that meet criteria

Dependent Array doesn't drop down after loading

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

[SOLVED] 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?