Sorry about that...I just tried it again and it is working. The first time I
tried it I was getting a value of "1" no matter what I was putting in the
list. My bad....Bob's formula did the trick afterall.

Thank you kindly.

"JE McGimpsey" wrote:

Bob's formula returns 3 (the number of repeat values) with your data.

What does "doesn't seem to be working" mean to you?


In article ,
"Repeatdude" wrote:

any other ideas?