G3 =IF(MAX(MMULT(TRANSPOSE((F3:F12=F3:F12)*1),IF(ISERROR(FIND(F3:F12,A3:C12)),0,1)))=COUNTA(F3:F12),"exists","non-exists")
Press Ctrl+Shift+Enter after inputing foruma
G3 =IF(MAX(MMULT(TRANSPOSE((F3:F12=F3:F12)*1),IF(ISERROR(FIND(F3:F12,A3:C12)),0,1)))=COUNTA(F3:F12),"exists","non-exists")
Press Ctrl+Shift+Enter after inputing foruma
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks