You'll need to provide more information. Why isn't the answer 3? ABC123 has
"Yes" in the row.

Regards,
Fred

"Mike JF" wrote in message
...
Dear Expert
I am a new to excel and i need to calculate the fill rate using the below
data.
My data is large , est around 2000 SKU lines
I try search from the post here, but no luck.
Appreciate your expertise.

Data Sample

Plate No. Date Ord.Ord No. SKU. Supp.
ABC123,12/1/08,123,Code1,Yes
ABC123,12/01/08,123,Code2,No
ABC124,13/01/08,125,Code3,Yes
ABC124,13/01/08,125,Code4,Yes
ABC125,13/01/08,126,Code5,Yes

I wish to get the answer how Plate No. with full parts supplied (yes) in
this case Ans: is 2 (ABC124 and ABC125) In addtion i may need to select by
date range.
Thank You
Mike