-2
votes
2answers
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
2answers
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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 ...