Quote Originally Posted by Ace_XL View Post
Have you tried the RANK function?

Something like..

=RANK(A1,$A$1:$A$100)
copied down....will work great for unique values
Very close to what I'm looking for. That ranks it on a 1-30 scale, but I need it converted to a 0-100 scale, (similar to a curve?).