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 quot;YESquot;.
TOTAL count of quot;YESquot; 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 ##
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.
adragton Wrote:
gt; Please see attachment- forum display messed up
gt;
gt; Multiple columns(A,B,C) which must be match against column
gt; Criteria(F,G,H).
gt; Column(D) displays EXACT MATCH quot;YESquot;.
gt; TOTAL count of quot;YESquot; displayed.
gt; example-
gt; ----Criteria-----
gt; A B C D F G H
gt; 11 aa 123 YES 11 aa 123
gt; 22 aa 123 NO
gt; 11 aa 123 YES
gt;
gt; TOTAL MATCH ##
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Image.jpg |
gt; |Download: /attachment.php?attachmentid=61|
gt; -------------------------------------------------------------------
gt;
gt; --
gt; adragton -------------------------------------------------------------------
|Filename: Iff.zip |
|Download: www.excelforum.com/attachment.php?postid=4560 |
-------------------------------------------------------------------
--
Door
------------------------------------------------------------------------
Door's Profile: www.excelforum.com/member.php...oamp;userid=33068
View this thread: www.excelforum.com/showthread...hreadid=528820
- Dec 25 Tue 2007 20:41
multiple column match per row
close
全站熱搜
留言列表
發表留言