Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
defintion of array function | Excel Discussion (Misc queries) | |||
Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
Array not working correctly Returns FALSE on second part | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |