LinkBack URL
About LinkBacks
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks