I got the same answer (76) with:
=MAX(IF(Masternaught!$B$2:$B$7629=Matrix!A2,Masternaught!$J$2:$J$7629))
confirmed with CTRL+SHIFT+ENTER not just ENTER
I got the same answer (76) with:
=MAX(IF(Masternaught!$B$2:$B$7629=Matrix!A2,Masternaught!$J$2:$J$7629))
confirmed with CTRL+SHIFT+ENTER not just ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks