Find largest or smallest value in a column based on duplicates in another column

I need two formulas that will identify the largest (or smallest) value in another column (X:X) among duplicate values in another colum (R:R) and and return "largest" (or "smallest).

R X formula1 formula2
123 1 smallest
456 2 smallest
123 3 largest
789 1
456 3 largest
123 2

Thanks in advance!

Yes. The forumula1 and formula2 columns are what I would want the formulas to return based on the values given i columns X and R.

Originally Posted by Tony Valko

Not real clear what you're wanting to do.

Do you want the words Largest/Smallest to appear when they apply?