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 o
the next row for all rows. I need to count every time there is
repeat but i don't want to count the first occurance just from th
second on. Each time the word in column G changes I need to start
new count. I would like to record the totals for each new word in co
G, in a new cell. For example for the first word I record the tota
number of repeats in cell H1, for the second word I record the numbe
of repeats in H2 and so on. Is this possible. If I have to d
something else with the totals that is ok. I have attached a smal
example of a spread sheet so you can visualize this.


Thank you for your help

Morr

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