duplicate rows

[robert morris]

I just need to identify any duplicate rows in a range.

Row G10:Z10
Row G11:Z11
Row G12:Z12 ........

Range of rows is G10 to G140

I've researched and found no help.

As I said, I don't need to do anything except identify them, if any.

Bob

 

[Paul Marks]

Robert

I would concatenate the columns. IE =Concatenate(g10,h10,i10 ect) in cell
f10 ect

copy the formula down to f140

then name a range between f10:f140 name it dups or something

the in cell e10 use the formula countif(dups,f10)

copy the formula down to e140

now place a filter on column E and look for entries > 1

I hope this helps

 

[robert morris]

Paul,

Sorry for the delay in replying. I've applied your instructions. Col F
shows all cells selected (all text) and Col E shows all "zeros". Here is
where I'm losing it. When I apply a filter >1, all rows "hide" except Row
10. Any idea what I'm doing wrong?

Bob

 

[Paul Marks]

Robert

Please send a blank email to (e-mail address removed)

I will send you a demo s/s

With Kind Regards

Paul