Searching for numbers within cells

Robert...that first formula is almost exactly what I was looking for. I do have one question.

When I place the formula in my my spreadhseet it calculates the missing sets of numbers but will only give a maximum of 6 results. Some comparison sets may have considerably more. Is there any way to make the output result and indefinite number of sets?

thanks,

dennis

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.