Hi!
I am new to excel and I need some generous help to solve my problem.
Hopefully there are someone kind in enough to help me.
Any way I thank you in advance.
I like Excel to count using only the unrepeated nos in Row1(A1:A4) are
repeating against the unrepeated nos in the range (A3:D6).

e.g.

A B C D E
Row1 0 0 1 2

Row3 0 0 0 0 1x
Row4 0 0 0 1 2x
Row5 0 0 0 2 2x
Row6 0 1 2 3 3x

How can I let excel to compare between Row1 against each row (Row3 to
Row6) and give me the answer in E3:E6



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

You have already been given an answer to this question or a very similar
question.

Why not start with why that solution does not work.

--
Regards,
Tom Ogilvy

"Michael168" wrote in message
...
Hi!
I am new to excel and I need some generous help to solve my problem.
Hopefully there are someone kind in enough to help me.
Any way I thank you in advance.
I like Excel to count using only the unrepeated nos in Row1(A1:A4) are
repeating against the unrepeated nos in the range (A3:D6).

e.g.

A B C D E
Row1 0 0 1 2

Row3 0 0 0 0 1x
Row4 0 0 0 1 2x
Row5 0 0 0 2 2x
Row6 0 1 2 3 3x

How can I let excel to compare between Row1 against each row (Row3 to
Row6) and give me the answer in E3:E6



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

The formula you give calculate wrongly if the nos in A1:D1 are repeating
or duplicate.

That's why I am seeking for help again.

Plse try to help me again.

Thank you to Tom.

With Regards.
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

OK - but it is best to remain in the same thead and provide that type of
feedback - then people can begin to work from that solution as a
possibility.

=(COUNTIF($A3:$D3,$A$1)0)+IF($A$1<$B$1,(COUNTIF( $A3:$D3,$B$1)0),0)+IF(COU
NTIF($A$1:$B$1,$C$1)=0,(COUNTIF($A3:$D3,$C$1)0),0 )+IF(COUNTIF($A$1:$C$1,$D$
1)=0,(COUNTIF($A3:$D3,$D$1)0),0)

in E3, then drag fill down to E6
provides the counts you show.

--
Regards,
Tom Ogilvy

"Michael168" wrote in message
...
The formula you give calculate wrongly if the nos in A1:D1 are repeating
or duplicate.

That's why I am seeking for help again.

Plse try to help me again.

Thank you to Tom.

With Regards.
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/