I have a spreadsheet with a lengthy list of numbers. I need to find
the smallest number that occurs twice. I also need to find the
smallest number that occurs three times, etc. Is there a way to do
this with a formula?

I don't mind running a macro to do this, but I would need help with
that as well. Placing the answer in a msgbox is fine with me.

thanks in advance.
jasonk