Hi
try
=SUMPRODUCT(--(B1:B99=B2:B100),--(G1:G99=G2:G100))

--
Regards
Frank Kabel
Frankfurt, Germany


There are numbers in col B and words in col G.
I need to compare Col B and Col G (together) to the same two columns
on the next row for all rows. I need to count every time there is a
repeat but i don't want to count the first occurance just from the
second on. Each time the word in column G changes I need to start a
new count. I would like to record the totals for each new word in
col
G, in a new cell. For example for the first word I record the total
number of repeats in cell H1, for the second word I record the number
of repeats in H2 and so on. Is this possible. If I have to do
something else with the totals that is ok. I have attached a small
example of a spread sheet so you can visualize this.


Thank you for your help

Morry

Attachment filename: sample.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=583708 ---
Message posted from http://www.ExcelForum.com/