## Complex Formula

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

## Compare two values in an array and if they match in a row, return a value from the third column in the same row.

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I …

## Sum If Array Formula Question

I’m trying to use an array formula with sumif and know the correct format is along the lines of …

## FORMULA HELP COMPARING TWO COLUMNS OF DATA THAT ARE NOT AN EXACT MATCH

Hello, If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation.  I …

## How to search through items with the same value to see if the meet criteria?

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

## How to search through items with the same value to see if the meet criteria?

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

## Populating dynamic array

Hello, I have a small VBA subroutine, which aims to put some data from a worksheet into a two dimensional dynamic array. When compiled line-by-line …

## INDEX Array problems

Hi AllI have a formula, that works! (Hooray!) But only with a manual entered INDEX array..The working formula …

## How to get rid of #DIV/0! in an array

Hi! I hope someone can help me with this question. I am trying to calculate the standard deviation of a row of cells, however i would like to not include any …

## Referring to a range (array?) in a cell.

Hi,   Sorry if my terminology is a bit off but I’m self taught on Excel.   My problem is that I need to be able to refer to a range/array in a …

## MR1984

Items Month Wk 10 Wk 11 Wk 12 Wk 13   Current Week Item 1 Item 2 Item 3 Item 12 Item 1 Mar 110 210 310 1210   Demand Item 1 Apr 120 220 320 1220 …

## Excel Array Help

Letter  Car  Value  Help    A     Sedan   1       0    B     Coupe …

## Get a cell reference of a value, in a worksheet (multi column/row, no “sorting” of values).

Looking for the function to state the cell reference of a given value in a worksheet (array). Value “2” ,located in A1, and located in …

## How can I conditionally format a cell, base on the contents of a different cell

Hi all, I apologize for the vague title. but I could not think of a way to properly explain the problem in a single line with so few characters… So I was …

## Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1} not recognized.

Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1}  not recognized. Request/Goal: I want to enter the …