Search Results - Excel Help Forum

[SOLVED] Sumproduct with Arrays of Different Sizes

Started by jglassmanba‎, 05-22-2012 08:57 PM

8

190

Last Post By:: Last Post: 05-25-2012 09:22 AM; by jglassmanba

Forum:
Excel General

[SOLVED] Array formula to filter a results set only matches first value in the array

Started by ulthima‎, 05-22-2012 02:35 PM

6

146

Last Post By:: Last Post: 05-26-2012 04:56 AM; by ulthima

Forum:
Excel General

Array Formula with Unique Counting gives error

Started by dim06‎, 05-17-2012 09:10 AM

2

73

Last Post By:: Last Post: 05-17-2012 09:46 AM; by dim06

Forum:
Excel Programming

Array formula error

Started by tkellymd‎, 05-14-2012 01:20 PM

3

108

Last Post By:: Last Post: 05-14-2012 02:50 PM; by Pepe Le Mokko

Forum:
Excel Programming

How does AND work in array formulas?

Started by RogeratCCCC‎, 04-27-2012 11:34 PM

6

218

Last Post By:: Last Post: 04-28-2012 07:31 AM; by martindwilson

Forum:
Excel - New Users

How to find out result by array formula

Started by alee001‎, 04-27-2012 11:50 AM

8

212

Last Post By:: Last Post: 04-28-2012 12:34 AM; by alee001

Forum:
Excel General

[SOLVED] What happens when I refer to a named range?

Started by RogeratCCCC‎, 04-21-2012 12:29 PM

4

156

Last Post By:: Last Post: 04-21-2012 04:06 PM; by RogeratCCCC

Forum:
Excel - New Users

[SOLVED] Array formula

Started by alee001‎, 04-17-2012 03:24 PM

2

157

Last Post By:: Last Post: 04-18-2012 04:26 AM; by alee001

Forum:
Excel General

array formula: sumprod with vlookup or sumif to search duplicates item once only

Started by Mayyalondon‎, 03-29-2012 04:17 PM

array formula, countif, duplicate items, sumproduct

4

251

Last Post By:: Last Post: 03-30-2012 07:55 AM; by daddylonglegs

Forum:
Excel Worksheet Functions

Conditional weighted average ignoring #N/A values

Started by syoung27‎, 02-21-2012 10:22 PM

#n/a, array formula, conditional, conditional averaging, weighted average

4

288

Last Post By:: Last Post: 02-22-2012 09:48 AM; by dilipandey

Forum:
Excel General

Extracting unique values from a column without zeros or n/a

Started by snoproladd‎, 02-13-2012 09:11 AM

11

360

Last Post By:: Last Post: 02-17-2012 10:26 AM; by snoproladd

Forum:
Excel General

How find LOWEST non-#NA value in a named range?

Started by Carrfamily‎, 02-11-2012 05:31 PM

3

234

Last Post By:: Last Post: 02-12-2012 07:41 PM; by Haseeb A

Forum:
Excel - New Users

I need help with Array formula??

Started by Jacen‎, 01-31-2012 11:41 AM

11

238

Last Post By:: Last Post: 02-14-2012 03:06 PM; by JBeaucaire

Forum:
Excel General

Array Formula - two worksheets, two criteria

Started by tdonov02‎, 12-19-2011 06:16 PM

array formula, criteria, formula, syntax

1

106

Last Post By:: Last Post: 12-19-2011 06:25 PM; by Special-K

Forum:
Excel General

VLOOKUP within array formula?

Started by swedeaction‎, 11-11-2011 03:47 AM

array formula, array help, help needed, vlookup help required

1

103

Last Post By:: Last Post: 11-11-2011 05:55 AM; by TMShucks

Forum:
Excel General

Unique value from two cols from two tabs?

Started by jimsablast‎, 11-09-2011 10:15 PM

3

104

Last Post By:: Last Post: 11-10-2011 11:02 PM; by Azam Ali

Forum:
Excel General

Tweak array IF(ISNUMBER(FIND formula

Started by Greed‎, 10-25-2011 12:12 PM

4

243

Last Post By:: Last Post: 10-25-2011 12:59 PM; by Greed

Forum:
Excel General

Ignoring blanks with array formula?

Started by jetimmins‎, 10-24-2011 10:55 AM

3

176

Last Post By:: Last Post: 10-25-2011 04:10 AM; by jetimmins

Forum:
Excel 2007 Help

Vlookup non-unique data, multiple values - array formula?

Started by doritos‎, 06-12-2011 02:39 AM

6

1,457

Last Post By:: Last Post: 06-14-2011 07:18 AM; by doritos

Forum:
Excel General

How to input array formula in vba and then copy it

Started by vivekchha‎, 04-22-2011 08:26 AM

3

416

Last Post By:: Last Post: 04-24-2011 10:28 AM; by vivekchha

Forum:
Excel Programming

Excel array formula, offset, index, match...

Started by flippertie‎, 03-17-2011 08:41 AM

6

1,320

Last Post By:: Last Post: 03-17-2011 09:42 AM; by NBVC

Forum:
Excel General

switching < > operator breaks array formula

Started by thebenshaw‎, 02-26-2011 07:39 PM

2

225

Last Post By:: Last Post: 02-26-2011 09:56 PM; by thebenshaw

Forum:
Excel General

'Begins with' style condition in array formula

Started by rova‎, 02-14-2011 04:40 PM

array, array formula, begins with, date and time, max function

2

491

Last Post By:: Last Post: 02-15-2011 07:55 PM; by rova

Forum:
Excel General

Display part of an array formula result

Started by brookhyserj‎, 02-06-2011 06:25 PM

1

545

Last Post By:: Last Post: 02-06-2011 11:57 PM; by shg

Forum:
Excel General

Array Formula with Dynamic Wild Card Criteria

Started by mildar‎, 12-29-2010 02:48 PM

array formula, excel 2010, sum function, wildcards

8

736

Last Post By:: Last Post: 12-30-2010 12:35 PM; by daddylonglegs

Forum:
Excel General

Indirect function combined with Array

Started by NYRealEstateAnalyst‎, 11-11-2010 11:23 AM

array formula, indirect reference, row formula

3

716

Last Post By:: Last Post: 11-11-2010 12:46 PM; by DonkeyOte

Forum:
Excel Worksheet Functions

VLOOKUP formula

Started by jmaterano‎, 10-25-2010 02:19 PM

10

1,000

Last Post By:: Last Post: 10-25-2010 06:05 PM; by outofthehat

Forum:
Excel General

Array Formula if 2 fields = display 3

Started by brownjc0‎, 10-24-2010 05:14 PM

3

189

Last Post By:: Last Post: 10-24-2010 09:48 PM; by NBVC

Forum:
Excel Programming

Replace hard coded array in formula with link to input array

Started by David Brown‎, 10-19-2010 10:09 AM

array formula, dynamic array, static array

8

756

Last Post By:: Last Post: 01-08-2011 06:45 AM; by David Brown

Forum:
Excel Worksheet Functions

How can I count rows from another file that meet certain criteria?

Started by thedestroyer‎, 10-14-2010 05:04 PM

array formula, countif, dcount, partial match, sum

0

176

Last Post By:: Last Post: 10-14-2010 05:04 PM; by thedestroyer

Forum:
Excel 2007 Help

Single Conditional Array x two Multi-Column Array - Approach needed

Started by David Brown‎, 09-28-2010 10:15 AM

array formula, sum - range of cells, sumproduct, what-if

2

411

Last Post By:: Last Post: 09-28-2010 11:41 AM; by David Brown

Forum:
Excel Worksheet Functions

Invert and transpose a range

Started by cesna123‎, 08-05-2010 12:26 PM

4

636

Last Post By:: Last Post: 08-05-2010 04:51 PM; by DonkeyOte

Forum:
Excel Programming

Dynamic array constants

Started by michalrosa‎, 07-01-2010 08:21 PM

3

564

Last Post By:: Last Post: 07-02-2010 04:01 AM; by DonkeyOte

Forum:
Excel Worksheet Functions

Sumif based on a text criteria and a date range

Started by PiR1‎, 06-02-2010 12:20 AM

array formula, reporting, sumif, sumif;many variables

2

2,652

Last Post By:: Last Post: 06-02-2010 12:53 AM; by JeffCPA

Forum:
Excel General

Counting non blank cells based on several conditions

Started by el1212‎, 04-28-2010 01:34 PM

1

152

Last Post By:: Last Post: 04-28-2010 01:48 PM; by NBVC

Forum:
Excel Worksheet Functions

Search:

Search: Replies Views Search took 0.01 seconds.

[SOLVED] Sumproduct with Arrays of Different Sizes

[SOLVED] Array formula to filter a results set only matches first value in the array

Array Formula with Unique Counting gives error

Array formula error

How does AND work in array formulas?

How to find out result by array formula

[SOLVED] What happens when I refer to a named range?

[SOLVED] Array formula

array formula: sumprod with vlookup or sumif to search duplicates item once only

Conditional weighted average ignoring #N/A values

Extracting unique values from a column without zeros or n/a

How find LOWEST non-#NA value in a named range?

I need help with Array formula??

Array Formula - two worksheets, two criteria

VLOOKUP within array formula?

Unique value from two cols from two tabs?

Tweak array IF(ISNUMBER(FIND formula

Ignoring blanks with array formula?

Vlookup non-unique data, multiple values - array formula?

How to input array formula in vba and then copy it

Excel array formula, offset, index, match...

switching < > operator breaks array formula

'Begins with' style condition in array formula

Display part of an array formula result

Array Formula with Dynamic Wild Card Criteria

Indirect function combined with Array

VLOOKUP formula

Array Formula if 2 fields = display 3

Replace hard coded array in formula with link to input array

How can I count rows from another file that meet certain criteria?

Single Conditional Array x two Multi-Column Array - Approach needed

Invert and transpose a range

Dynamic array constants

Sumif based on a text criteria and a date range

Counting non blank cells based on several conditions