Count Unique values grouping on multiple columns

[jvishnu46]

Hi

Sample Data:

COL A , COL B, COL C, COL D
S1, SIMPLE, A , 10
S1, SIMPLE, B , 20
S2, MEDIUM, A, 20
S2, MEDIUM, B, 30
S3, SIMPLE, A, 20
S3, SIMPLE, C, 40

COL A data is unknown but COL B, COL C data is pre defined values.

i want the distict record count for group of COL A ,COL B and COL C.

output:

Col 1, SIMPLE,MEDIUM,
A, 2, 1
B, 1, 1
C , 1, 0

Please let me know the formula to use.

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks