Array help Part 2
maybe you need to re-post on other forum
"driller" wrote:
Almost got it !
from previous question of Luke "Array Help" yesterday, where the checked
answer is :
on B1
=IF(AND(SUMPRODUCT(--ISNUMBER(MATCH($C$1:$E$3,F1,0))),SUMPRODUCT(--ISNUMBER(MATCH($C$1:$E$3,G1,0))),SUMPRODUCT(--ISNUMBER(MATCH($C$1:$E$3,H1,0)))),(F1&G1&H1)+0,"")
Please reply for an answer that is good for the following arrangement.
A B C D E F G H
1 1 * 0 3 5 9
2 X y Z 7 4 4
3 100 9 8 5 1 0 0
4 2 1 3
5 6 4 3
6 #value! X y Z
7 1 6 4
8 #value! z Z *
9 4 4 4
10 950 9 5 0
11 #value! X x Z
I hope it's easy to modify for advance learning...thanks...
|