Repeat Values in rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Governor - 09 Oct 2007 09:56 GMT

I need to search my worksheet (128 X 128) rows for any repeated values,
anyone help?

Reply to this Message

David Biddulph - 09 Oct 2007 10:52 GMT

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.

Signature

David Biddulph

>I need to search my worksheet (128 X 128) rows for any repeated values,
> anyone help?

Reply to this Message

Governor - 09 Oct 2007 11:11 GMT

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.

> 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
[quoted text clipped - 3 lines]
> >I need to search my worksheet (128 X 128) rows for any repeated values,
> > anyone help?

Reply to this Message

David Biddulph - 09 Oct 2007 12:14 GMT

In which case just change the 128 to 1:
=COUNTIF($A$1:$DX$1,A1)<>1

Signature

David Biddulph

> Thanks David, but what I need is to select row 1 for instance accross all
> 128
[quoted text clipped - 8 lines]
>> >I need to search my worksheet (128 X 128) rows for any repeated values,
>> > anyone help?

Reply to this Message

David Biddulph - 09 Oct 2007 12:22 GMT

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

Signature

David Biddulph

> In which case just change the 128 to 1:
> =COUNTIF($A$1:$DX$1,A1)<>1

>> Thanks David, but what I need is to select row 1 for instance accross all
>> 128
[quoted text clipped - 9 lines]
>>> >I need to search my worksheet (128 X 128) rows for any repeated values,
>>> > anyone help?

Reply to this Message