How do I check repeating sets of number in a range
 

If 1, 9, 13, 15, 33, 42, 49 are numbers that appear in my first row. How can
I find out if 9,15 and 42 as set, do appear in the same row in a range of my
worksheet and how many times do the appear

Hi Tshidiso,

You may want to check this: http://tinyurl.com/8o56f

Regards,
KL


"Tshidiso" wrote in message
...
If 1, 9, 13, 15, 33, 42, 49 are numbers that appear in my first row. How
can
I find out if 9,15 and 42 as set, do appear in the same row in a range of
my
worksheet and how many times do the appear