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
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
In which case just change the 128 to 1:
=COUNTIF($A$1:$DX$1,A1)<1

"Governor" wrote in message
...
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.

"David Biddulph" wrote:

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.
--
David Biddulph

"Governor" wrote in message
...
I need to search my worksheet (128 X 128) rows for any repeated values,
anyone help?