arrays - Search Results - Excel Help Forum

Filtering/sorting the data using excel formulas/arrays

Started by ExMAN999‎, 09-08-2014 06:07 PM

4

18,903

Last Post By:: Last Post: 09-09-2014 07:45 PM; by FDibbins

Forum:
Excel Formulas & Functions

Formula to find number sick leave instances and hours before and after stat holiday

Started by Therese‎, 08-21-2014 10:33 PM

5

925

Last Post By:: Last Post: 08-23-2014 12:28 AM; by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

INDEX / MATCH FUNCTIONS - Multiple Criteria Between Date Ranges

Started by JMData Consultant‎, 07-22-2014 10:41 AM

arrays, date range, index, match, multiple criteria

3

2,703

Last Post By:: Last Post: 07-22-2014 02:25 PM; by JMData Consultant

Forum:
Excel Formulas & Functions

[SOLVED] Array of Ranges to work out average value PROBLEM!

Started by AndresJanes‎, 07-19-2014 08:30 PM

arrays, excel, problem ---- can't solve, vba

4

555

Last Post By:: Last Post: 07-19-2014 09:12 PM; by mikerickson

Forum:
Excel Programming / VBA / Macros

Dynamic Array

Started by Nazariy‎, 05-31-2014 11:21 AM

11

1,085

Last Post By:: Last Post: 06-01-2014 02:41 PM; by gsnidow

Forum:
Excel Programming / VBA / Macros

Search a value from array between particular indices.

Started by lifeankit‎, 05-30-2014 04:26 AM

1

455

Last Post By:: Last Post: 05-30-2014 04:29 AM; by nathansav

Forum:
Excel Programming / VBA / Macros

[SOLVED] Building subarrays with multiple criteria

Started by jbalan‎, 05-29-2014 09:12 PM

8

2,951

Last Post By:: Last Post: 11-10-2014 06:00 PM; by ohdiana

Forum:
Excel Formulas & Functions

Need Help with Arrays

Started by DeanJS‎, 04-10-2014 03:20 PM

1

463

Last Post By:: Last Post: 04-10-2014 03:21 PM; by DeanJS

Forum:
Excel Programming / VBA / Macros

Separate (not remove) duplicates

Started by rockell333‎, 03-11-2014 02:13 PM

arrays, duplicates macro, formulas 2010, separate data, vba

1

478

Last Post By:: Last Post: 03-11-2014 02:45 PM; by bsalv

Forum:
Excel Programming / VBA / Macros

[SOLVED] Referring at an Array in different worksheet

Started by Holbeck_Ghyll‎, 03-05-2014 10:19 AM

2

558

Last Post By:: Last Post: 03-05-2014 10:42 AM; by Holbeck_Ghyll

Forum:
Excel Formulas & Functions

Daily totals using an array & SumIfs

Started by jginrey‎, 01-13-2014 12:38 PM

2

783

Last Post By:: Last Post: 01-13-2014 03:10 PM; by jginrey

Forum:
Excel Formulas & Functions

Help with arrays

Started by casdesigns41‎, 01-12-2014 08:01 PM

2

495

Last Post By:: Last Post: 01-12-2014 09:04 PM; by FDibbins

Forum:
Excel Formulas & Functions

Return value different than "" from a data array.

Started by markom92‎, 01-03-2014 01:17 PM

2

625

Last Post By:: Last Post: 01-03-2014 02:03 PM; by markom92

Forum:
Excel General

Create 12 month rolling chart

Started by bberger1985‎, 12-19-2013 12:24 PM

0

778

Last Post By:: Last Post: 12-19-2013 12:24 PM; by bberger1985

Forum:
Excel Programming / VBA / Macros

[SOLVED] Problems with arrays in function

Started by Sherk‎, 11-27-2013 02:47 PM

6

843

Last Post By:: Last Post: 11-27-2013 03:45 PM; by Sherk

Forum:
Excel Programming / VBA / Macros

[SOLVED] Basic issue with array/range For Each loop

Started by chrishar‎, 11-05-2013 11:48 PM

3

522

Last Post By:: Last Post: 11-06-2013 12:12 AM; by chrishar

Forum:
Excel Programming / VBA / Macros

Creating arrays from multiple worksheets

Started by ashuperstar‎, 10-18-2013 12:26 PM

2

773

Last Post By:: Last Post: 10-18-2013 12:58 PM; by ashuperstar

Forum:
Excel Formulas & Functions

[SOLVED] Using the Changing values of a range to construct a new data array

Started by Romulo‎, 09-25-2013 01:48 PM

7

689

Last Post By:: Last Post: 09-26-2013 08:06 AM; by tehneXus

Forum:
Excel Programming / VBA / Macros

[SOLVED] Looping the rows of an Array into a one range of rows repeatedly

Started by Romulo‎, 09-25-2013 02:09 AM

2

608

Last Post By:: Last Post: 09-25-2013 10:54 AM; by Romulo

Forum:
Excel Programming / VBA / Macros

Numeric intervals

Started by staedtler‎, 09-24-2013 11:26 PM

5

673

Last Post By:: Last Post: 09-25-2013 03:09 AM; by nilem

Forum:
Excel Programming / VBA / Macros

Creating a New dataarray from an existing datarray after calculations take place

Started by Romulo‎, 09-24-2013 11:01 PM

2

674

Last Post By:: Last Post: 09-25-2013 12:21 AM; by Romulo

Forum:
Excel Programming / VBA / Macros

VBA FormulaArray

Started by jadown‎, 09-19-2013 11:10 AM

4

1,400

Last Post By:: Last Post: 09-19-2013 11:52 AM; by jadown

Forum:
Excel Programming / VBA / Macros

Trying to input data from one sheet based on two criterias on another

Started by danikva‎, 09-03-2013 10:52 AM

1

669

Last Post By:: Last Post: 09-03-2013 07:39 PM; by RobertMika

Forum:
Excel Formulas & Functions

Excel VBA: Arrays, Using a string to define an Array of Worksheets

Started by Brianandstewie‎, 08-22-2013 10:31 PM

arrays, loop "do until", string array, worksheets

7

1,317

Last Post By:: Last Post: 08-23-2013 12:40 AM; by jindon

Forum:
Excel Programming / VBA / Macros

Teasing Monthly Returns from intra month returns

Started by spcw‎, 08-14-2013 04:33 PM

4

1,082

Last Post By:: Last Post: 08-14-2013 05:14 PM; by spcw

Forum:
Excel Formulas & Functions

[SOLVED] Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

Started by jimalya‎, 08-14-2013 03:08 PM

arrays, elements, errorchecking, worksheets

2

707

Last Post By:: Last Post: 08-14-2013 04:16 PM; by jimalya

Forum:
Excel Programming / VBA / Macros

[SOLVED] Locating the position of the MIN value across cells from multiple sheets

Started by rhercz‎, 07-21-2013 06:28 AM

arrays, min, min and max function, multiple sheets

8

2,792

Last Post By:: Last Post: 07-21-2013 07:54 AM; by martindwilson

Forum:
Excel Formulas & Functions

[SOLVED] Validating Item Numbers

Started by Julez80s‎, 07-02-2013 08:27 PM

9

880

Last Post By:: Last Post: 07-05-2013 12:31 PM; by Julez80s

Forum:
Excel Programming / VBA / Macros

quantitative anomaly-- inconsistent values, help me find formula error!

Started by mtmorce‎, 06-21-2013 03:00 PM

arrays, countblank, formula, inconsistent results, occurences of text

7

1,185

Last Post By:: Last Post: 06-21-2013 03:27 PM; by aydeegee

Forum:
Excel Formulas & Functions

[SOLVED] Conditionally Formatting Against Benchmark Scores

Started by martinpgibson‎, 06-12-2013 01:52 AM

3

1,726

Last Post By:: Last Post: 06-12-2013 02:13 AM; by dilipandey

Forum:
Excel General

Using the LOOKUP function to extract numbers from sentences

Started by velda‎, 06-02-2013 11:58 PM

1

832

Last Post By:: Last Post: 06-03-2013 12:04 AM; by velda

Forum:
Excel Formulas & Functions

Global Array

Started by peternorth‎, 05-16-2013 10:12 AM

0

439

Last Post By:: Last Post: 05-16-2013 10:12 AM; by peternorth

Forum:
Excel Programming / VBA / Macros

IF for arrays

Started by youngbld‎, 05-10-2013 12:21 PM

arrays, condition formula, formula building

10

776

Last Post By:: Last Post: 05-10-2013 02:54 PM; by Norie

Forum:
Excel Formulas & Functions

[SOLVED] New to arrays-Resizing cell range when writing array

Started by mc84excel‎, 05-09-2013 07:53 PM

array, arrays, closed workbook, dimension, vba array

2

626

Last Post By:: Last Post: 05-09-2013 08:31 PM; by mc84excel

Forum:
Excel Programming / VBA / Macros

New to arrays-How do I copy an entire row from one array to another?

Started by mc84excel‎, 05-08-2013 11:57 PM

array, arrays, copying between arrays, vba array

16

9,044

Last Post By:: Last Post: 05-15-2013 12:19 AM; by mc84excel

Forum:
Excel Programming / VBA / Macros

Search:

Search: Replies Views Search took 0.01 seconds.

Filtering/sorting the data using excel formulas/arrays

Formula to find number sick leave instances and hours before and after stat holiday

INDEX / MATCH FUNCTIONS - Multiple Criteria Between Date Ranges

[SOLVED] Array of Ranges to work out average value PROBLEM!

Dynamic Array

Search a value from array between particular indices.

[SOLVED] Building subarrays with multiple criteria

Need Help with Arrays

Separate (not remove) duplicates

[SOLVED] Referring at an Array in different worksheet

Daily totals using an array & SumIfs

Help with arrays

Return value different than "" from a data array.

Create 12 month rolling chart

[SOLVED] Problems with arrays in function

[SOLVED] Basic issue with array/range For Each loop

Creating arrays from multiple worksheets

[SOLVED] Using the Changing values of a range to construct a new data array

[SOLVED] Looping the rows of an Array into a one range of rows repeatedly

Numeric intervals

Creating a New dataarray from an existing datarray after calculations take place

VBA FormulaArray

Trying to input data from one sheet based on two criterias on another

Excel VBA: Arrays, Using a string to define an Array of Worksheets

Teasing Monthly Returns from intra month returns

[SOLVED] Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

[SOLVED] Locating the position of the MIN value across cells from multiple sheets

[SOLVED] Validating Item Numbers

quantitative anomaly-- inconsistent values, help me find formula error!

[SOLVED] Conditionally Formatting Against Benchmark Scores

Using the LOOKUP function to extract numbers from sentences

Global Array

IF for arrays

[SOLVED] New to arrays-Resizing cell range when writing array

New to arrays-How do I copy an entire row from one array to another?