array - Search Results - Excel Help Forum

[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

581

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

1,895

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

543

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

508

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

366

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

566

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

729

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

460

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

381

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

350

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

570

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

467

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

535

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

388

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

345

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

Forum:
Excel Programming / VBA / Macros

Delete duplicate entry if both entries have corresponding pairs

Started by immigrated4urjob‎, 08-10-2021 12:39 PM

6

415

Last Post By:: Last Post: 08-12-2021 09:52 AM; by jindon

Forum:
Excel Programming / VBA / Macros

[SOLVED] Help optimizing this code

Started by mike-lowski‎, 08-01-2021 07:13 AM

3

351

Last Post By:: Last Post: 08-02-2021 08:50 AM; by Richard Buttrey

Forum:
Excel Programming / VBA / Macros

Find Max Value in an Array and return the Column Title

Started by jamesbrown2020‎, 07-24-2021 06:03 AM

4

412

Last Post By:: Last Post: 07-24-2021 06:26 AM; by AliGW

Forum:
Excel General

Extract Unique Value from 2 lists and sort ascending

Started by Cathrine Paul‎, 07-16-2021 10:17 AM

array, index and match and if, small, unique

3

469

Last Post By:: Last Post: 07-17-2021 10:53 AM; by AliGW

Forum:
Excel Formulas & Functions

Populate table column with array

Started by primed‎, 07-15-2021 02:24 AM

3

521

Last Post By:: Last Post: 07-15-2021 06:28 AM; by torachan

Forum:
Excel Programming / VBA / Macros

How to assign a Filtered Column of Dates Criteria Value to a Variable

Started by JMaz‎, 07-09-2021 09:52 AM

array, criteria, filter, table, vba & excel

3

367

Last Post By:: Last Post: 07-09-2021 10:14 AM; by cubangt

Forum:
Excel Programming / VBA / Macros

Return Multiple Rows based on Multiple Criteria

Started by Matt_Turner‎, 06-30-2021 11:45 AM

5

471

Last Post By:: Last Post: 07-08-2021 11:53 AM; by alansidman

Forum:
Excel Formulas & Functions

Finding Top 3 Largest Values from List and Returning Value to Left

Started by djc123‎, 06-26-2021 12:33 AM

3

472

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

Forum:
Excel Formulas & Functions

Table only displays last value from arrray

Started by Fernando14‎, 06-24-2021 10:48 AM

2

284

Last Post By:: Last Post: 06-24-2021 11:07 AM; by rorya

Forum:
Excel Programming / VBA / Macros

[SOLVED] Cumulative present value in a single function

Started by lacrimosus1028‎, 06-22-2021 12:40 AM

2

805

Last Post By:: Last Post: 06-22-2021 01:28 AM; by lacrimosus1028

Forum:
Excel Formulas & Functions

[SOLVED] Excel automation errors with arrays in office 365

Started by dentler‎, 06-20-2021 09:49 PM

activex combo box, array, automation error, office 365

3

685

Last Post By:: Last Post: 06-23-2021 10:28 AM; by dentler

Forum:
Excel Programming / VBA / Macros

[SOLVED] Help finding a tutorial/guide for searching VBA Arrays

Started by Darth269‎, 06-17-2021 06:59 AM

5

394

Last Post By:: Last Post: 06-20-2021 11:59 AM; by Darth269

Forum:
Excel Programming / VBA / Macros

Which is faster: For-loop or For Each-loop with integer?

Started by Rezzy777‎, 05-12-2021 04:21 AM

array, for ... each loops, for ... next loops, speed

13

657

Last Post By:: Last Post: 05-12-2021 05:29 AM; by Rezzy777

Forum:
Excel Programming / VBA / Macros

[SOLVED] Creating a static vlookup formula

Started by nyKnicks2021‎, 05-11-2021 12:43 PM

3

815

Last Post By:: Last Post: 05-11-2021 03:02 PM; by Greg M

Forum:
Excel General

Dictionary of Arrays to Range

Started by Rezzy777‎, 05-10-2021 04:39 AM

37

2,057

Last Post By:: Last Post: 05-11-2021 02:30 AM; by Rezzy777

Forum:
Excel Programming / VBA / Macros

[SOLVED] Index and Filter Functions: Workaround to sort, filter, and format within array?

Started by beginner21‎, 04-25-2021 12:50 PM

11

769

Last Post By:: Last Post: 04-25-2021 04:48 PM; by Fluff13

Forum:
Excel Formulas & Functions

Finding parts of a text from the full table of possible matches - FIND? Array?

Started by apoje‎, 04-21-2021 05:37 AM

1

625

Last Post By:: Last Post: 04-21-2021 05:39 AM; by apoje

Forum:
Excel General

How to convert an array of numbers to an ascending list

Started by costgeek‎, 04-20-2021 05:41 AM

4

816

Last Post By:: Last Post: 04-20-2021 06:54 AM; by Bo_Ry

Forum:
Excel General

Match between multiple values in single cells and lookup-list

Started by cercig‎, 04-14-2021 08:42 AM

3

379

Last Post By:: Last Post: 04-14-2021 10:38 AM; by cercig

Forum:
Excel Programming / VBA / Macros

Baffled by mysterious mm/dd/yyyy date format

Started by iwaddo‎, 04-11-2021 10:56 AM

12

708

Last Post By:: Last Post: 04-13-2021 03:33 AM; by iwaddo

Forum:
Excel Programming / VBA / Macros

Search:

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

[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

Delete duplicate entry if both entries have corresponding pairs

[SOLVED] Help optimizing this code

Find Max Value in an Array and return the Column Title

Extract Unique Value from 2 lists and sort ascending

Populate table column with array

How to assign a Filtered Column of Dates Criteria Value to a Variable

Return Multiple Rows based on Multiple Criteria

Finding Top 3 Largest Values from List and Returning Value to Left

Table only displays last value from arrray

[SOLVED] Cumulative present value in a single function

[SOLVED] Excel automation errors with arrays in office 365

[SOLVED] Help finding a tutorial/guide for searching VBA Arrays

Which is faster: For-loop or For Each-loop with integer?

[SOLVED] Creating a static vlookup formula

Dictionary of Arrays to Range

[SOLVED] Index and Filter Functions: Workaround to sort, filter, and format within array?

Finding parts of a text from the full table of possible matches - FIND? Array?

How to convert an array of numbers to an ascending list

Match between multiple values in single cells and lookup-list

Baffled by mysterious mm/dd/yyyy date format