Formula or VBA code help

  • Thread starter Thread starter Michael168
  • Start date Start date
M

Michael168

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
 
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.
 
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
 
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.
 
Back
Top