How do I check repeating sets of number in a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting of duplicates in a range 2
Number Match Formula? 7
Function in Excel to count and list number of entries of text valuesin a row. 2
Formula (or code) return the largest number of duplicates in a list. 16
How Do I Query a Named Range 2
count a pair of numbers in row in a table 1
Repeat the macro using different ranges 1
Finding values in different rows/columns 1

Back
Top