| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a value for a number in a range | Excel Discussion (Misc queries) | |||
| how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . | Excel Discussion (Misc queries) | |||
| How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Why is it important to check the range placed in the SUM function. | Excel Worksheet Functions | |||
Linear Mode
