Searching for numbers within cells

Hi Dennis,

Yes, I set the formula based on your original data to return a maximum of 6 x 3 set of (unique) results. While the formula can be extended to some degree, I think Excel's formula limit if 1,024 characters in any one will cell will kick in before "the output result for an indefinite number of sets" is possible.

Perhaps someone out there has created a "User Defined Function" (UDF) to handle this (or a very) similar situation though the indefinite part is always going to problematic.

Good luck with your search

Robert

Thanks for your assistance.