Apologies,
this is the formula that bring back the date no matter when the sku
appears
=max(C1:C100*if(B1:B100=K1, 1, 0))

C includes the date and B is the SKU.

i now want to bring back the qty and qty counted


rgds
Gordon