For Each Row in Range

[pwill]

Hi can anyone help with a macro or line of code that I can add to another macro?

I have data in "E4:K4" ​

and "E5:K26" Sheet1

For Each Row in Range

"E5:K26" if any Value is the same as any value in

Range "E4:K4" and the Count of the same Values For Each Row that Match/Duplicate any Value in

"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>

​

​

Row "E5:K5" has a Count of 1 Value that is the same in

"E4:K4"

Row "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>
</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>
</strike>}}​

Any help would be much appreciated

Regards

pwill

 

[MickG]

You're welcome