Hi can anyone help with a macro or line of code that I can add to another macro?
For Each Row in Range
Regards
pwill
I have data in "E4:K4"
and "E5:K26" Sheet1For Each Row in Range
"E5:K26" if any Value is the same as any value in
Row "E5:K5" has a Count of 1 Value that is the same in Range "E4:K4" and the Count of the same Values For Each Row that Match/Duplicate any Value in
ie
<colgroup><col span="13"></colgroup><tbody>
</tbody>
"E4:K4"
is 1 then clear the duplicate cell for each row when the Count is only 1 (or less than 2)ie
A | B | C | D | E | F | G | H | I | J | K | L | |
1 | ||||||||||||
2 | ||||||||||||
3 | ||||||||||||
4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||||
5 | 21 | 33 | 2 | 10 | 8 | 19 | 12 | |||||
6 | 4 | 3 | 55 | 70 | 23 | 15 | 20 | |||||
7 | 11 | 16 | 18 | 7 | 40 | 46 | 28 | |||||
8 | 1 | 7 | 32 | 45 | 85 | 78 | 22 | |||||
9 | 31 | 27 | 36 | 83 | 62 | 77 | 6 | |||||
10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
<colgroup><col span="13"></colgroup><tbody>
</tbody>
"E4:K4"
</strike>Row "E7:K7" has a Count of 1 Value that is the same in "E4:K4"
</strike>Row "E10:K10" has a Count of 7 Values that are the same in "E4:K4"
So the results would be
G5 = Nothing
H7 =
<colgroup><col span="13"></colgroup><tbody>
</tbody><strike>
</strike>
Any help would be much appreciatedRow "E6:K6" has a Count of 2 Values that are the same in "E4:K4"
<strike></strike>Row "E7:K7" has a Count of 1 Value that is the same in "E4:K4"
Row "E8:K8" has a Count of 2 Values that are the same in "E4:K4"
Row "9:K9" has a Count of 1 Value that is the same in "E4:K4"
<strike>Row "9:K9" has a Count of 1 Value that is the same in "E4:K4"
</strike>Row "E10:K10" has a Count of 7 Values that are the same in "E4:K4"
So the results would be
G5 = Nothing
H7 =
Nothing
K9 = Nothing
A | B | C | D | E | F | G | H | I | J | K | L | |
1 | ||||||||||||
2 | ||||||||||||
3 | ||||||||||||
4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||||
5 | 21 | 33 | 10 | 8 | 19 | 12 | ||||||
6 | 4 | 3 | 55 | 70 | 23 | 15 | 20 | |||||
7 | 11 | 16 | 18 | 40 | 46 | 28 | ||||||
8 | 1 | 7 | 32 | 45 | 85 | 78 | 22 | |||||
9 | 31 | 27 | 36 | 83 | 62 | 77 | ||||||
10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
<colgroup><col span="13"></colgroup><tbody>
</tbody>
</strike>
Regards
pwill