countif - issue (no duplicates)

Originally Posted by NBVC

Try:

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX(Data!$CW$12:$CW$76,MATCH(0, INDEX(COUNTIF(Calculations!C$51:C51,Data!$CW$12:$CW$75),0),0))))

confirmed with just ENTER and copied down.

for some odd reason, it was giving me doubles? but i really appreciate the help, u guys are the best!