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

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 …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.