1st and 2nd.... positions

[T. Valko]

That doesn't work for any rank that ends in 0 (10th, 20th). CHOOSE causes an
error.

Also, use it on a large range (more than 10 cells) and you'll see it returns
incorrect results for other ordinals.

 

[T. Valko]

You're welcome. Thanks for the feedback!

Here are a couple of good sites with loads of info:

http://cpearson.com/excel/mainpage.aspx

http://contextures.com/