Count Unique in one colum based on matches in other Column

Hi.....I am not the sharpest pencil in the box..............

I have a spreadsheet of sku numbers in one column and a list of finishes in another column. I'm trying to set a column that will show the number of unique finishes available for that one sku. My sheet looks like this:

Col B Col C
121026 Mahogany
121026 Bronze
121026 Dark Smoke
121026 Burnished Steel
121026 Black
121026 Natural Iron
121025 Mahogany
121025 Mahogany
121025 Mahogany
121025 Mahogany
121025 Bronze
121025 Bronze
121025 Bronze
121025 Bronze
121025 Dark Smoke
121025 Dark Smoke
121025 Dark Smoke
121025 Dark Smoke
121025 Burnished Steel
121025 Burnished Steel
121025 Burnished Steel
121025 Burnished Steel
121025 Black
121025 Black
121025 Black
121025 Black
121025 Natural Iron
121025 Natural Iron
121025 Natural Iron
121025 Natural Iron
126755 Mahogany
126755 Mahogany

I don't mind that the cell will repeat the countif down the column. In fact, I may use a separate sheet later listing only one sku and use the formula in only one cell based on the other sheet as reference. I think part of it is:

=SUM(1/COUNTIF(C3:C31,C3:C31))CONTROL+SHIFT+ENTER........I don't know how to make it use this for only a group of exact skus. I'm guessing to use a Vlookup to create the range references for countif?

Thanks....BTW...is there an easier way to paste a sample table in the post? (I'm a newbie!)

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View PicHow to attach a sample Excel workbook:

1. Below the "Quick Reply" thread frame, click the "Go Advanced" button.
2. On the edit toolbar, click the "Attachments" button.
3. In the "File Upload Manager" window, click the "Add Files" button.
4. In the "Upload Files from your Computer" window, click the "Select Files" button.
5. In the Windows Explorer window, locate and select your workbook, then click the "Open" button.
6. In the "Upload Files from your Computer" window, click the "Upload Files" button.
7. In the "File Upload Manager" window, click the "Done" button (lower right of screen).