Yes folks...yet another one
I do attempt them.....miserably obv...
In the attached workbook I have placed two helper Cols to assist the formula.
Cheers
hammer
apologies Ford![]()
Yes folks...yet another one
I do attempt them.....miserably obv...
In the attached workbook I have placed two helper Cols to assist the formula.
Cheers
hammer
apologies Ford![]()
P2=IF(COUNTIF(ALL!H$2:H$2120,AS2),"YES","NO")
or
P2=IF(ISERROR(MATCH(AS2,ALL!H$2:H$2120,0)),"NO","YES")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Cheers Champ!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks