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/