Thanks for the feedback.

I would use Jack's solution as it uses standard functions (... so thanks
also to you Jack for filling in another gap in my knowledge).

"5dolla" wrote:

>
> Thanks Jack Sheet, I will definitely give that a shot in my next
> worksheet, I have 3 moe that I have to perform this on.
>
> There seems to be so many short formulas to do more complicated things
> than what I'm doing, it's wierd that the formulas to count the number
> of rows that a value occurs multiple times would require so much, but
> screw it, it works so I'm happy and grateful beyond words that I don't
> have to sit and manually do a find then count the occurrences.
>
> You folk are FN brilliant!
>
> Thank-you Thank-you Thank-you Thank-you Thank-you Thank-you Thank-you
> Thank-you Thank-you Thank-you Thank-you Thank-you Thank-you Thank-you
>
>
> --
> 5dolla
> ------------------------------------------------------------------------
> 5dolla's Profile: http://www.excelforum.com/member.php...o&userid=36493
> View this thread: http://www.excelforum.com/showthread...hreadid=562529
>
>