Results 1 to 3 of 3

Thread: much numbers

  1. #1

    much numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 ?

  2. #2
    Try

    =ISNUMBER(FIND(Q1,A12))

  3. #3
    Quote Originally Posted by bob phillips View Post
    try

    =isnumber(find(q1,a12))
    solved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •