Cell A1 contains:(ALL)
7717173.SLDDRW 7717174.SLDDRW 7717176.SLDDRW 7718475.SLDDRW 7718476.SLDDRW 7718477.SLDDRW
Cell B1 contains:(1st 3) 7717173.SLDDRW 7717174.SLDDRW 7717176.SLDDRW
Cell B2 contains:(last 3) 7718475.SLDDRW 7718476.SLDDRW 7718477.SLDDRW
i'd like to use column c to validate if all numbers entered in A1 exist in any cell in column B.
Aucun commentaire:
Enregistrer un commentaire