I would not be surprised if there isn't a much more elegant solution than
mine. Someone will doubtless post one

"5dolla" <5dolla.2b5neh_1153249507.5888@excelforum-nospam.com> wrote in
message news:5dolla.2b5neh_1153249507.5888@excelforum-nospam.com...
>
> 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
>