Determine Top 5 in Column

I want to determine the top 5 in a column based on 2 different categories.

I'll have column A with unique names, column B with only values Red or Blue, then column C with Numberic Values. I want to calculate the top 5 highest value Red's based on the value in column C and the top 5 Blue's based on the values in column C. I want to list those 5 values from column C in column D for the Top 5 Red's and column E for the top Blues.

Any thoughts?

thanks,
Mark

I am looking to do a very similar thing, so I'll be watching this thread. Thanks!