JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have a column of numbers. I watered them down for this example below.
I am looking for a macro that will search EACH GROUP of numbers and find any dups. If there are none then go on to the next group and so on. I am not trying to find dup numbers in the entire column, just in each group.
After it finds a dupe I need it to note in a previous column.
The group size will be larger and vary in size but there should be at least 1 empty line between each grouping.
I've tried the macro's that look at the entire column but nothing seems to work for what I need.
Thanks for your help
James
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
I am looking for a macro that will search EACH GROUP of numbers and find any dups. If there are none then go on to the next group and so on. I am not trying to find dup numbers in the entire column, just in each group.
After it finds a dupe I need it to note in a previous column.
The group size will be larger and vary in size but there should be at least 1 empty line between each grouping.
I've tried the macro's that look at the entire column but nothing seems to work for what I need.
Thanks for your help
James
26 | |
Dupe | 34 |
Dupe | 34 |
42 | |
9 | |
15 | |
17 | |
22 | |
22 | |
Dupe | 2 |
Dupe | 2 |
13 | |
14 | |
49 | |
2 | |
6 | |
14 | |
21 | |
28 | |
Dupe | 1 |
Dupe | 1 |
8 | |
11 | |
24 |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>