Unique Count

Hi everyone ,
Newbie here , it looks a great resource this site ,, wonder if anyone can help me

we have a set of data in 2 columns column A and column B , we would like be able to do a unique count of column B in relation to column A, with the output showing unique items in column A`s and a count of Unique items in Column B


example below ; the output would be A 1 ( as there is only 1 unique item Red) , B 2 ( there are 2 unique items ) , C 3 ( 3 unique items Yellow white and black )

i know it can be done with pivot table but we wish to just copy the data daily to a spreadsheet and have the output columns calculate automatically .. any help is greatly greatly recieved thanks in advance

Column A Column B
A Red
A Red
B Green
B Lime
C Yellow
C Yellow
C white
C Black

Thanks everyone for the information, i think i might have confused things attached is an example of the real data , the principle is the same , column A and Column B are pasted in every day , what i am looking for is column I to show the unique items in Column A , ie only 1 of each MRP controller listed , ie 1 of A15, 1 of C10 etc , this list does vary slightly every day , and then for column J to show the unique count of column B related to column A ( or column I ) ... apprecaite a little more help ... thanks in advance

thanks to you both , now working a treat apprecaite the help