Hi everyone,

I am stuck and need help

For the table below, I want to count column Part_ID for unique value by specifying a range matching text value on column Lot_ID.
In other words, say I want to count unique number of Part_ID matching only Lot_ID value T2C532. In this case the returned value should be 3

Part_Number Lot_ID Part_ID Lot_Part
1 T2C531 1 T2C531-1
3 T2C531 2 T2C531-2
7 T2C531 3 T2C531-3
9 T2C531 1 T2C531-1
11 T2C531 3 T2C531-3
16 T2C532 1 T2C532-1
17 T2C532 3 T2C532-3
18 T2C532 5 T2C532-5
19 T2C532 3 T2C532-3
21 T2C532 1 T2C532-1
24 T2C533 2 T2C533-2
25 T2C533 3 T2C533-3
27 T2C533 4 T2C533-4
29 T2C533 5 T2C533-5
31 T2C533 3 T2C533-3
33 T2C533 2 T2C533-2


Thanks much