average from unique cell values

[miming1986]

How do i get the pass rate without using the data on column H to J?
Please see attached file. Thanks in advance!

 

[NARAYANK991]

Hi ,

See if this is correct.

Narayan

 

[Asheesh]

Hi,

If you are after 54.55% then use the below construction

SUM(--(FREQUENCY(IF(AVERAGEIF(D2:D37,D2:D37,E2:E37)=1,MATCH(D2:D37,D2:D37,0)),ROW(A1:A37))>1))/SUM(--(FREQUENCY(MATCH(D2:D37,D2:D37,0),MATCH(D2:D37,D2:D37,0))>0))

Acknowledge with CTRL + SHIFT + ENTER