joewagner501
New Member
- Joined
- Aug 20, 2015
- Messages
- 7
I have wracked my brain and Google searches for several days trying to find an answer to my dilemma. Hopefully someone here can help with it.
I have a range of numbers within a large set of numbers that will repeat. For example, in the range below, the first nine numbers are a range that repeats afterward. This is a simple example because sometimes the repeat range may be 50 or more in length.
Is there a formula or macro that will scan a set of numbers to determine where the repeat range begins? In the example below, the ninth number is the last of the range that repeats and is therefore considered the beginning of the repeat range.
<colgroup><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
Any help would be greatly appreciated.
I have a range of numbers within a large set of numbers that will repeat. For example, in the range below, the first nine numbers are a range that repeats afterward. This is a simple example because sometimes the repeat range may be 50 or more in length.
Is there a formula or macro that will scan a set of numbers to determine where the repeat range begins? In the example below, the ninth number is the last of the range that repeats and is therefore considered the beginning of the repeat range.
14.00 |
13.00 |
14.00 |
13.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
13.00 |
14.00 |
13.00 |
14.00 |
13.00 |
<colgroup><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
Any help would be greatly appreciated.