# Tagged Questions

**-2**

votes

**2**answers

36 views

### identify the rows with the lowest values in an array based on identical values in a column of that array

I have an array of product data which includes code, description and cost. code is unique, cost is numeric and description is non-unique. Please see example. How can I select the cheapest of each ...

**1**

vote

**2**answers

27 views

### Simple, Excel, =LOOKUP(xxxxx), not returning the correct value

OK this is infuriating as I know this should work...
I have certain traits in column A. Each trait has a corresponding value in column B and a numeric indicator of that value in column C. Like ...

**3**

votes

**2**answers

39 views

### Define value of a column by another column in Excel

This seems like it should be so simple! I need to define column B by column A
If column A is equal to any value in the array "taco,burger,spaghetti" column B should read "food", if column A is equal ...

**0**

votes

**1**answer

121 views

### Excel formula to sum the total for a specific person in a specific month

I need help with an Excel formula that sums the total or work for a specific person in a specific month. Here is what my data looks like:
I need to setup a formula to extract automatically the sum ...

**0**

votes

**2**answers

34 views

### Force a one-dimensional array into a constant in Excel

I have a condition in an Excel IF-statement as follows:
INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))=1
where
INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))
eveluates to ...

**0**

votes

**0**answers

68 views

### IF word in A1 matches word in Col C AND word in B1 matches word in Col E AND

Cell A1 contains a paragraph made of Hebrew words (They are Bible verses in Hebrew, so sometimes more than 254 characters long in each cell).
Cell B1 contains a paragraph of English words (They are ...

**2**

votes

**1**answer

482 views

### Excel array formulas to find smallest date with multiple criteria

The array formula I have will give me the smallest date from a Service table, based on the following criteria:
1) The value in the item column matches the item # in cell A1
2) The value in the ...

**1**

vote

**1**answer

131 views

### Getting a MAX using AVERAGEIFS logic

I have a table of data that I want to find a MAX value for.
The challenge is filtering the values I care about.
Basically, I want the MAX from Column D when:
Column A = 'VIC'
Column B = 'CBD'
...

**0**

votes

**2**answers

267 views

### Can an array input be used in the sheet name of vlookup's range?

I have a formula which works, but is absurdly long, but repeats the core data over and over.
My spreadsheet contains 70 pages describing sets of cards. The page I'm working on gives me a particular ...

**3**

votes

**1**answer

2k views

### Excel Range with IF

Is there a function that will create a range (from a range) if they match values? Essentially, I'm looking for something like COUNTIF, that will return the cells that actually match my IF.
Ideally, ...

**2**

votes

**1**answer

1k views

### Request: Excel equivalent of Google Spreadsheet ARRAYFORMULA + CONTINUE functionality

Google Spreadsheets has a syntax permitting a user to specify an entire row, column, or area with a formula in a single cell. For example, entering ...
=ARRAYFORMULA(ROW(A3:A6))
... into cell C1 ...

**1**

vote

**2**answers

134 views

### Is there any documentation of the behavior of built-in Excel functions called with array arguments?

(I originally asked this on stackoverflow. However, Excel formulas definitely straddle the line between "programming" and, um, "superusing", so I believe this cross-post is appropriate.)
Many of ...