Not sure how much faster it would be, but looks like you could use countifs instead of sumproduct..
And that is always preferable if it's possible..
=IF(COUNTIFS($BM$3:$BM3,BM3,$CU$3:$CU3,CU3)>1,0,1)
Not sure how much faster it would be, but looks like you could use countifs instead of sumproduct..
And that is always preferable if it's possible..
=IF(COUNTIFS($BM$3:$BM3,BM3,$CU$3:$CU3,CU3)>1,0,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks