## 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 …

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 …

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 …

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

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 …

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 …

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 …

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

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 …

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 …

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 …

Letter Car Value Help A Sedan 1 0 B Coupe …

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 …

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. Request/Goal: I want to enter the …