COUNT Unique using Frequency

Dear all,

I have a excel table with duplicate bill id, i want to get the unique count. However, it should also consider another criteria, which is customer. Should I use advanced filter instead? How should the advanced filter be set?

kw42chan