Determine if an integer is not in a list

[ImranBhatti]

Hi,

To be more concise

is it possible to determine if an integer is not in a list of integers just like the string as bellow

[!def] a character that is not d,e or f

I want

[!676777] an integer that is not 6,7,67 or 77

I want to avoid a loop on

array(6,7,67,77)

Help would be greatly appreciated


Imran Bhatti

[PCI]

Perhaps
C3 = the number to check
F3 = the list of numbers, starting and finishing by , e.g. ,6,7,67,77,
Somewhere =NOT(LEN(SUBSTITUTE(F3,"," & C3 & ",",""))=LEN(F3))

[PCI]

With UDF

Please Login or Register  to view this content.

[ImranBhatti]

Hi PCI

Thanks for the review. I will let you know about the output of your function once I am on the PC where the file containing string exists.

Thanks once again for the efforts to help out.

[jindon]

Please Login or Register  to view this content.

[ImranBhatti]

jindon and PCI first of all my apologies for too late response. I was on sick leaves.

PCI would you please correct me if I am not using your udf correctly? because it is producing "Error 13, Type mismatch"

Please Login or Register  to view this content.

Jindon's function is working as I needed (Thank so much jindon)

[PCI]

The input list must be a string ..... not the roght input it seems ...!

Please Login or Register  to view this content.