array - Search Results - Excel Help Forum

Comparing (2) Rows of Data

Started by martybrodeur‎, 07-18-2019 05:33 PM

7

629

Last Post By:: Last Post: 07-19-2019 10:15 AM; by AliGW

Forum:
Excel Formulas & Functions

Lookup Value In Table Based on 2 Criteria

Started by tf_2119‎, 07-17-2019 10:52 AM

array, lookup, lookup 2 criteria's, lookup 2 value in table, lookup and match

5

408

Last Post By:: Last Post: 07-17-2019 05:00 PM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Match 3 cells are equal or not, return results in a row array

Started by lmattenl‎, 07-17-2019 01:58 AM

9

491

Last Post By:: Last Post: 07-17-2019 03:50 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Data sorting/filtering

Started by KylieD‎, 07-16-2019 08:57 AM

aggregate, array, convert, filter, if(and)

11

758

Last Post By:: Last Post: 07-25-2019 04:19 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Array reference in a cell: difference using or not array formulas

Started by RiccardoS89‎, 07-04-2019 06:51 AM

array, array formula, array reference, reference a cell

8

862

Last Post By:: Last Post: 07-05-2019 12:07 PM; by RiccardoS89

Forum:
Excel Formulas & Functions

RANK, SMALL formulas inside the array argument (no CTRL+SHIFT+ENTER)

Started by ExcelQuestion‎, 07-02-2019 04:24 PM

2

528

Last Post By:: Last Post: 07-03-2019 08:09 AM; by XOR LX

Forum:
Excel Formulas & Functions

Array with Subscript Out of Range Error

Started by TxTitan‎, 07-01-2019 05:45 PM

20

985

Last Post By:: Last Post: 07-03-2019 08:51 AM; by Fluff13

Forum:
Excel Programming / VBA / Macros

Create a List off Multiple Criteria

Started by jbshiver‎, 06-26-2019 12:48 PM

5

411

Last Post By:: Last Post: 06-30-2019 04:31 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] Retrieve values from string.

Started by ABBOV‎, 06-24-2019 09:30 AM

3

424

Last Post By:: Last Post: 06-24-2019 12:05 PM; by Arkadi

Forum:
Excel Programming / VBA / Macros

[SOLVED] INDEX MATCH for multiple criteria

Started by treegee‎, 06-21-2019 03:52 PM

array, index, match, multiple criteria columns

8

1,514

Last Post By:: Last Post: 06-24-2019 01:22 PM; by treegee

Forum:
Excel Formulas & Functions

[SOLVED] VBA for an Array / VLOOKUP

Started by xAcrosonicx‎, 06-20-2019 11:37 PM

3

319

Last Post By:: Last Post: 06-21-2019 12:28 AM; by FDibbins

Forum:
Excel Programming / VBA / Macros

Screen turns white & tables behaving differently

Started by button clicker‎, 06-13-2019 12:12 PM

3

346

Last Post By:: Last Post: 06-13-2019 02:42 PM; by Tsjallie

Forum:
Excel Programming / VBA / Macros

Add a condition to an array function containing INDEX MATCH

Started by ErikWi‎, 06-12-2019 02:11 AM

3

587

Last Post By:: Last Post: 06-13-2019 07:06 AM; by Bo_Ry

Forum:
Excel Formulas & Functions

[SOLVED] Need help speeding this loop. Hide/unhide 1200 columns based on boolean criteria

Started by button clicker‎, 06-11-2019 02:25 PM

1

457

Last Post By:: Last Post: 06-11-2019 04:57 PM; by mjr veverka

Forum:
Excel Programming / VBA / Macros

[SOLVED] Worksheetfunction.min not working with array

Started by SJGORILLA‎, 05-30-2019 08:18 AM

array, excel 2016, vba, worksheetfunction, worksheetfunction.min

6

1,509

Last Post By:: Last Post: 05-31-2019 06:01 AM; by SJGORILLA

Forum:
Excel Programming / VBA / Macros

[SOLVED] VBA - Array - Select Ranges Based Upon Criteria

Started by VBAye‎, 05-23-2019 08:14 PM

array, array conditional, range array, vba

7

633

Last Post By:: Last Post: 05-24-2019 12:04 AM; by VBAye

Forum:
Excel Programming / VBA / Macros

Array sorting

Started by AxiAngel‎, 05-23-2019 03:43 AM

5

629

Last Post By:: Last Post: 05-23-2019 07:25 AM; by dangelor

Forum:
Excel Programming / VBA / Macros

Array to Display Row of Data

Started by profess‎, 05-17-2019 05:59 PM

7

853

Last Post By:: Last Post: 05-26-2019 04:03 PM; by JeteMc

Forum:
Excel Formulas & Functions

Create an array from matching values in multiple columns

Started by Fresh_Outlook‎, 05-16-2019 06:29 AM

1

552

Last Post By:: Last Post: 05-20-2019 01:14 PM; by JeteMc

Forum:
Excel General

[SOLVED] Help need with vba arrays, using with formulas

Started by SiyaG‎, 05-15-2019 04:06 AM

5

411

Last Post By:: Last Post: 05-15-2019 07:06 AM; by SiyaG

Forum:
Excel Programming / VBA / Macros

How do I find most recent dates for one person with repeated values in no specific order?

Started by louhilla‎, 05-14-2019 04:49 PM

1

467

Last Post By:: Last Post: 05-15-2019 02:56 AM; by Pepe Le Mokko

Forum:
Excel Formulas & Functions

[SOLVED] How to equate array variables to other array variables in a formula

Started by Geode7‎, 05-13-2019 01:43 AM

9

598

Last Post By:: Last Post: 05-13-2019 04:45 AM; by sintek

Forum:
Excel Programming / VBA / Macros

Find sum of difference in a single column based on criterias.

Started by ankitpsaraogi‎, 05-09-2019 02:34 PM

2

529

Last Post By:: Last Post: 05-10-2019 04:14 AM; by ankitpsaraogi

Forum:
Excel Formulas & Functions

Please delete

Started by ggmkp‎, 05-02-2019 02:08 AM

5

621

Last Post By:: Last Post: 05-05-2019 12:14 PM; by ggmkp

Forum:
Excel Programming / VBA / Macros

Large formula looking at a pivot table that updates as you select from data validation

Started by amartin575‎, 04-19-2019 01:52 PM

array, data validation, large, pivot table

1

559

Last Post By:: Last Post: 04-23-2019 06:51 AM; by XLent

Forum:
Excel Formulas & Functions

[SOLVED] Multidimensional Array vs (extended) One dimensional Array

Started by EchoPassenger‎, 04-17-2019 03:12 PM

8

404

Last Post By:: Last Post: 04-17-2019 04:11 PM; by EchoPassenger

Forum:
Excel Programming / VBA / Macros

using indirect in vlookup to insert search range

Started by smakatura‎, 04-16-2019 09:19 AM

array, indirect, referene range, vlookup

1

514

Last Post By:: Last Post: 04-16-2019 09:51 AM; by Special-K

Forum:
Excel Formulas & Functions

[SOLVED] Data validation - character limit - array

Started by dunnobe‎, 04-16-2019 08:42 AM

2

794

Last Post By:: Last Post: 04-16-2019 10:03 AM; by dunnobe

Forum:
Excel Programming / VBA / Macros

[SOLVED] VBA get unique visible items from table column and generate drop-down entries

Started by godlev‎, 04-08-2019 07:36 AM

5

769

Last Post By:: Last Post: 04-10-2019 08:37 AM; by godlev

Forum:
Excel Programming / VBA / Macros

Change FONT color based upon a list of items

Started by Wefunk‎, 04-04-2019 01:20 PM

1

368

Last Post By:: Last Post: 04-04-2019 09:15 PM; by jindon

Forum:
Excel Programming / VBA / Macros

Analyzing Large Data Table to Generate a Pareto Table Using Array Function

Started by BotFV4‎, 03-25-2019 01:09 PM

12

925

Last Post By:: Last Post: 03-27-2019 03:14 PM; by XLent

Forum:
Excel Formulas & Functions

[SOLVED] Transforming Data Set

Started by d7882‎, 03-25-2019 11:30 AM

2

441

Last Post By:: Last Post: 03-25-2019 12:16 PM; by d7882

Forum:
Excel Formulas & Functions

VBA Code: Consolidate multiple workbooks into one workbook

Started by LukeVBA‎, 03-14-2019 12:37 AM

array, consolidation from files, consolidation macro, vba, vba (macros)

0

442

Last Post By:: Last Post: 03-14-2019 12:37 AM; by LukeVBA

Forum:
Excel Programming / VBA / Macros

jagged arrays

Started by esbencito‎, 03-12-2019 06:53 AM

6

1,149

Last Post By:: Last Post: 03-18-2019 12:42 AM; by esbencito

Forum:
Excel Programming / VBA / Macros

Function needed to execute a minor of 2*2 matrix

Started by Nkrekor‎, 03-09-2019 02:34 AM

1

605

Last Post By:: Last Post: 03-09-2019 02:51 AM; by AliGW

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.01 seconds.

Comparing (2) Rows of Data

Lookup Value In Table Based on 2 Criteria

[SOLVED] Match 3 cells are equal or not, return results in a row array

[SOLVED] Data sorting/filtering

[SOLVED] Array reference in a cell: difference using or not array formulas

RANK, SMALL formulas inside the array argument (no CTRL+SHIFT+ENTER)

Array with Subscript Out of Range Error

Create a List off Multiple Criteria

[SOLVED] Retrieve values from string.

[SOLVED] INDEX MATCH for multiple criteria

[SOLVED] VBA for an Array / VLOOKUP

Screen turns white & tables behaving differently

Add a condition to an array function containing INDEX MATCH

[SOLVED] Need help speeding this loop. Hide/unhide 1200 columns based on boolean criteria

[SOLVED] Worksheetfunction.min not working with array

[SOLVED] VBA - Array - Select Ranges Based Upon Criteria

Array sorting

Array to Display Row of Data

Create an array from matching values in multiple columns

[SOLVED] Help need with vba arrays, using with formulas

How do I find most recent dates for one person with repeated values in no specific order?

[SOLVED] How to equate array variables to other array variables in a formula

Find sum of difference in a single column based on criterias.

Please delete

Large formula looking at a pivot table that updates as you select from data validation

[SOLVED] Multidimensional Array vs (extended) One dimensional Array

using indirect in vlookup to insert search range

[SOLVED] Data validation - character limit - array

[SOLVED] VBA get unique visible items from table column and generate drop-down entries

Change FONT color based upon a list of items

Analyzing Large Data Table to Generate a Pareto Table Using Array Function

[SOLVED] Transforming Data Set

VBA Code: Consolidate multiple workbooks into one workbook

jagged arrays

Function needed to execute a minor of 2*2 matrix