On 2002-10-30 00:05, gopa wrote:
PaddyD
It's OK, now I've spotted a few minor glitches(mine, not yours) and remembered to Ctrl+Shift+Enter EVERY time I edited!
This is real gen for the kind of things I am often doing, many, many thanks.
HughJ
On 2002-10-30 00:05, Aladin Akyurek wrote:
On 2002-10-29 23:50, IML wrote:
what about a good, old fashion sumproduct?
[...]
Ian,
That's dangerous. change A8 to "a" and try Me=a and You=f.
Aladin
Book2 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | a | e | ae | 1 | |||
2 | b | e | be | 2 | |||
3 | c | e | ce | 3 | |||
4 | d | e | de | 4 | |||
5 | a | f | af | 5 | |||
6 | b | f | bf | 6 | |||
7 | c | f | cf | 7 | |||
8 | a | f | af | 8 | |||
9 | |||||||
10 | |||||||
11 | me | a | |||||
12 | you | f | |||||
13 | index | 5 | |||||
14 | sumproduct | 13 | |||||
15 | vlookup | 5 | |||||
Sheet4 |
On 2002-10-30 00:23, IML wrote:
On 2002-10-30 00:05, Aladin Akyurek wrote:
On 2002-10-29 23:50, IML wrote:
what about a good, old fashion sumproduct?
[...]
Ian,
That's dangerous. change A8 to "a" and try Me=a and You=f.
Aladin
Good point, but what is the right answer here? 5, 8 or 13. I was (rightly or wrongly) assuming only unique combinations.
Playing with Colo's toy, I added your vlookup option (I will try not to get carried away with this)
[...]
On 2002-10-29 23:37, Aladin Akyurek wrote:
On 2002-10-29 23:26, Yogi Anand wrote:
Hi gopa:
Or the following non-array formula:
=VLOOKUP(B10,{"a",1;"b",2;"c",3;"d",4},2,0)+MATCH(B11,B1:B8,0)-1
[...]
Sort the data on column A and try...
Me b
You f
On 2002-10-30 10:34, Yogi Anand wrote:
One can use the DGET function ... see the following simulation:[...]