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 :) ?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=ISNUMBER(FIND(Q1,A12))
 
Top