multiple column match per row

A

adragton

Please see attachment- forum display messed up

Multiple columns(A,B,C) which must be match against column
Criteria(F,G,H).
Column(D) displays EXACT MATCH "YES".
TOTAL count of "YES" displayed.
example-
----Criteria-----
A B C D F G H
11 aa 123 YES 11 aa 123
22 aa 123 NO
11 aa 123 YES

TOTAL MATCH ##


+-------------------------------------------------------------------+
|Filename: Image.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=61|
+-------------------------------------------------------------------+
 
D

Door

I didn't see your original question, but the attached should help,
either to match to F1 G1 and H1 (rows 1 to 3) or to the corresponding
column F G and H entry for the row.


Please see attachment- forum display messed up

Multiple columns(A,B,C) which must be match against column
Criteria(F,G,H).
Column(D) displays EXACT MATCH "YES".
TOTAL count of "YES" displayed.
example-
----Criteria-----
A B C D F G H
11 aa 123 YES 11 aa 123
22 aa 123 NO
11 aa 123 YES

TOTAL MATCH ##


+-------------------------------------------------------------------+
|Filename: Image.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=61|
+-------------------------------------------------------------------+
Click to expand...


+-------------------------------------------------------------------+
|Filename: Iff.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4560 |
+-------------------------------------------------------------------+
 
Top