array - Search Results - Excel Help Forum

Index array?

Started by Kaloyanides‎, 09-04-2019 07:55 AM

1

383

Last Post By:: Last Post: 09-04-2019 08:09 AM; by Fluff13

Forum:
Excel Programming / VBA / Macros

[SOLVED] Structured reference: get all row data from one column that matches another, return Y/N

Started by CaysE‎, 08-28-2019 01:32 PM

array, index, lookup, match, structured reference

4

1,228

Last Post By:: Last Post: 08-29-2019 10:40 PM; by CaysE

Forum:
Excel Formulas & Functions

[SOLVED] Help to modify formula so that it only searches for whole string

Started by Thintin‎, 08-28-2019 08:12 AM

5

459

Last Post By:: Last Post: 08-28-2019 09:17 AM; by Fluff13

Forum:
Excel Formulas & Functions

SUM of VLOOKUP*ARRAY gives different answer when used as single cell

Started by the Core‎, 08-19-2019 10:34 AM

array, cse, multicell, result, single cell

5

418

Last Post By:: Last Post: 08-19-2019 11:49 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

Combining Multiple Tabs to one with array functions and removing blank rows

Started by drudd75077‎, 08-15-2019 10:54 AM

9

566

Last Post By:: Last Post: 08-21-2019 04:19 PM; by drudd75077

Forum:
Excel General

Analysing multiple values in an array

Started by Mark_G_‎, 08-09-2019 05:49 PM

2

370

Last Post By:: Last Post: 08-10-2019 03:33 AM; by Mark_G_

Forum:
Excel Formulas & Functions

[SOLVED] Assistane with IF array formula needed

Started by GuineaPig82‎, 08-08-2019 08:08 AM

array, arrayformula, formula, helpme, time

9

621

Last Post By:: Last Post: 08-08-2019 10:38 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Solution to extract orders for certain location and loop for all locations

Started by MrLukeSkyGuy‎, 08-07-2019 09:01 PM

6

527

Last Post By:: Last Post: 08-14-2019 01:47 AM; by sintek

Forum:
Excel Programming / VBA / Macros

[SOLVED] Get column value based on cell valued with duplicates

Started by dna7gran‎, 08-07-2019 07:22 PM

array, data array, duplicates, index, match

14

786

Last Post By:: Last Post: 08-10-2019 09:37 PM; by Gregb11

Forum:
Excel General

Extracting cell values but keeping out the blanks in original order.

Started by ATundal‎, 08-07-2019 07:33 AM

1

425

Last Post By:: Last Post: 08-07-2019 08:35 AM; by XLent

Forum:
Excel Formulas & Functions

Pulling single cell from multiple possible columns using multiple criteria columns

Started by Barren_Wuffett‎, 08-05-2019 09:20 AM

1

467

Last Post By:: Last Post: 08-05-2019 09:24 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Libre Office: Dragging down VLOOKUP function

Started by mmmmmmmmmmmmmmmmmmmm‎, 08-05-2019 08:49 AM

14

1,329

Last Post By:: Last Post: 08-06-2019 05:30 AM; by mmmmmmmmmmmmmmmmmmmm

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

Paste array into filtered range

Started by esbencito‎, 08-04-2019 11:34 PM

0

879

Last Post By:: Last Post: 08-04-2019 11:34 PM; by esbencito

Forum:
Excel Programming / VBA / Macros

Need Help With an Array

Started by jamesq‎, 08-02-2019 10:10 PM

5

475

Last Post By:: Last Post: 08-04-2019 11:29 AM; by AliGW

Forum:
Excel General

[Solved] Pulling info from multiple possible columns using multiple criteria columns

Started by Barren_Wuffett‎, 08-02-2019 06:13 PM

8

654

Last Post By:: Last Post: 08-08-2019 05:37 PM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Selecting top Vendor Items based on conditions

Started by chandramouliarun‎, 07-29-2019 07:40 AM

4

712

Last Post By:: Last Post: 07-30-2019 04:19 AM; by chandramouliarun

Forum:
Excel Formulas & Functions

[SOLVED] Show unique categories with corresponding sum of values

Started by cherrydee‎, 07-24-2019 11:56 PM

2

460

Last Post By:: Last Post: 07-25-2019 03:06 AM; by davsth

Forum:
Excel General

Grouping data by sum, not sum based on group!

Started by Hamasuta‎, 07-24-2019 11:43 AM

6

497

Last Post By:: Last Post: 07-25-2019 07:36 AM; by Hamasuta

Forum:
Excel Formulas & Functions

Filter results based on selected date

Started by TimBell‎, 07-20-2019 12:23 AM

1

437

Last Post By:: Last Post: 07-20-2019 02:10 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Filter results based on selected date

Started by TimBell‎, 07-19-2019 07:17 PM

9

805

Last Post By:: Last Post: 07-20-2019 04:49 AM; by AliGW

Forum:
Excel Formulas & Functions

Comparing (2) Rows of Data

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

7

630

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

320

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,510

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

Forum:
Excel Programming / VBA / Macros

Search:

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

Index array?

[SOLVED] Structured reference: get all row data from one column that matches another, return Y/N

[SOLVED] Help to modify formula so that it only searches for whole string

SUM of VLOOKUP*ARRAY gives different answer when used as single cell

Combining Multiple Tabs to one with array functions and removing blank rows

Analysing multiple values in an array

[SOLVED] Assistane with IF array formula needed

[SOLVED] Solution to extract orders for certain location and loop for all locations

[SOLVED] Get column value based on cell valued with duplicates

Extracting cell values but keeping out the blanks in original order.

Pulling single cell from multiple possible columns using multiple criteria columns

[SOLVED] Libre Office: Dragging down VLOOKUP function

Paste array into filtered range

Need Help With an Array

[Solved] Pulling info from multiple possible columns using multiple criteria columns

[SOLVED] Selecting top Vendor Items based on conditions

[SOLVED] Show unique categories with corresponding sum of values

Grouping data by sum, not sum based on group!

Filter results based on selected date

[SOLVED] Filter results based on selected date

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