much numbers

gogosikara

New member
Joined
Feb 18, 2014
Messages
2
Reaction score
0
Points
0
I need to write many numbers in ONE CELL and see if any of them much numbers from cell COLUMN

example: cell A12 value: 123 9876 34567 ( there an be separator if it is need it like comma -> 123, 9876, 34567 )

column Q1=534 folse
Q2=123 true (much)
Q3=76334 folse
Q4=34567 true (much)

Is it possible :) ?
 
Try

=ISNUMBER(FIND(Q1,A12))
 
Back
Top