G
Guest
I need to search my worksheet (128 X 128) rows for any repeated values,
anyone help?
anyone help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
It doesn't sound like a charrting question, but in your worksheet (having
selected your 128*128 range & with cell A1 active), use Format/ Conditional
Formatting/ Formula Is:
=COUNTIF($A$1:$DX$128,A1)<>1
and select a format to mark your duplicates.
selected your 128*128 range & with cell A1 active), use Format/ Conditional
Formatting/ Formula Is:
=COUNTIF($A$1:$DX$128,A1)<>1
and select a format to mark your duplicates.
G
Guest
Thanks David, but what I need is to select row 1 for instance accross all 128
columns and to find if any of the cells contain the same data.
columns and to find if any of the cells contain the same data.
D
David Biddulph
In which case just change the 128 to 1:
=COUNTIF($A$1:$DX$1,A1)<>1
=COUNTIF($A$1:$DX$1,A1)<>1
D
David Biddulph
But if you're wanting to do the same for each row in turn you'll need to
make the row reference relative, not absolute:
=COUNTIF($A1:$DX1,A1)<>1
make the row reference relative, not absolute:
=COUNTIF($A1:$DX1,A1)<>1