vendredi 19 août 2016

How to find partial values in a cell in a column?

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