B. R.,

Thanks. I would like to take credit for it, but I learned that technique a looooong time ago from
people who are much smarter <vbg

Bernie
MS Excel MVP

Bernie,
The formula you have suggested is extremely elegant (in the way it works).
Regards,
B. R. Ramachandran

"Bernie Deitrick" wrote:

You could simply sort the column ascending.

If your values are in a1:a5, then the formula

=SUMPRODUCT((A1$A$1:$A$5)*1)+1