All Questions
92
questions
0
votes
0
answers
331
views
Why are array formulas not filling adjacent cells as they should?
When using formula arrays with multi-cell results, the returned array is outputted in the adjacent cells as the formular arrays (as I've experienced in the past and as documented).
Why is it that if ...
0
votes
1
answer
272
views
Excel: Array formula to sum values based on matching month and year results in value error
I am trying to sum a bunch of numeric values in
'Product Detail zPart (ALL TIME)'!$O:$O
using formula
{=SUMPRODUCT((MONTH('Product Detail zPart (ALL TIME)'!$F:$F)=MONTH(Summary!C$2))*(YEAR('...
0
votes
2
answers
1k
views
Formula for finding longest string match in a cell from a list and returning the matching string
In an Excel workbook, I have a formula that searches for matches to a cell from a list. It works, but doesn't find the longest string match. How do I modify the formula so it returns the longest ...
-1
votes
2
answers
323
views
Excel Sumif Array
I'm trying to use an array formula with sumif and know the correct format is along the lines of
=sum(sumif(A:A,B:B,{"hello","hi"})),
However when I try to use > or < than operators, the ...
1
vote
2
answers
11k
views
Excel INDEX MATCH looking between two dates of my choosing
I'm using Excel to log a list of items (name of items in column D) and then how long that item took to produce in column G.
I'm doing an INDEX MATCH to search for the worst performing product of the ...
0
votes
1
answer
51
views
Excel array (2 variables)
I have the following sheet https://1drv.ms/x/s!Ai6fM6lT5gt6h00EUCmpnuwlgNtr
It consists of table 1 that is populated by a list (with an array).
Goal: I want to populate a second table based on the ...
1
vote
0
answers
30
views
Using an array to output results from a lookup criteria
I've tried searching the site, so sorry if this is a repeat. I'm not sure exactly how to phrase what I'm trying to do in excel.
Essentially what I have is a data sheet and a summary sheet. On the ...
0
votes
3
answers
223
views
Simple Array Formula in Excel not comparing the right values
I'm trying to calculate with an Array Formula (in Cell D2) what i'm calculating in cell D11. The issue i'm having is that it appears my Array Formula is not evaluating the inputted array one-by-one. ...
0
votes
0
answers
213
views
Excel: Ignore the last value in series 1 if COUNT(series1) > COUNT(series2)
I am currently using excel to do some trading. In one series I have a column of "buy prices" and the column next to it is "sell prices".
I want to divide all of my sell prices by all of my buy ...
2
votes
1
answer
3k
views
Find position of first uppercase character in excel string
I need to find the position of the first uppercase character in an Excel string. There are lots of resources on the web that have the same (or effectively the same) solution for this:
=MIN(IF(ISERROR(...
1
vote
2
answers
202
views
Count max values compared with previous array
I try to count the number of values in a row that are equal are greater to MAX() value of a (part) of the column above.
For example: compared to the 3 cells above itself. In E comes the 'count'.
i ...
0
votes
1
answer
111
views
Excel - Find the document of a given type, with the closest due date
I am operating on 2 Tables.
"Table 1" is a list of current documents that I import and want to keep unchanged. The file is unformatted in any way.
Table 2 is a list of customers that I operate upon ...
0
votes
1
answer
3k
views
Return list of all values that match any of a few criteria
I'm new to this site so hope I'm doing this right!
I've made use of @BruceWayne array formula in the answer to the follow question:
Return list of all values that match criteria
My question is, can ...
1
vote
2
answers
298
views
LookUP Value returning multiple concatenated values
I have two columns, one is a 'Category' with a simple code and the other column named 'Tree/group qualities' with one, or many of the following categories that are, if multiple, concatenated using ...
1
vote
0
answers
74
views
MAX Result of multpiple results from INDEX and MATCH
I am working with 3 columns, fname, lname, & date. Where there will be multiple duplicates of fname and lname. I am trying to write an INDEX & MATCH that will display the MAX result or the ...