1, 2, 3 large value based criteria

[marreco]

I try find a 1, 2, 3 large value based criteria
look my file

Thank you!!

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[bosco_yip]

Another option and try this non-array formula.

J2, copy across and down :

=IFERROR(LOOKUP(2,1/(($A$2:$A$194=$I2)*(COUNTIF($I2:I2,$B$2:$B$194)=0)),$B$2:$B$194),"")

Regards
Bosco

 

[marreco]

Thank you both!!