HI everyone.

Would like to first thank you for your help in advance. I really need help on this.

I would like to be able to count duplicate in a column up to 5 and restart back at 1 on the 6th duplicate data and display the count on the next column.


Column H --------Column I (Count)
1.Apple ------------- 1
2.Apple ------------- 2
3.Apple ------------- 3
4.Apple ------------- 4
5.Apple ------------- 5
6.Apple ------------- 1
7.Apple ------------- 2
8.Pear -------------- 1

(the dash is to show that the data is in separate columns)
Please help me out. Thank you so much .