Menu

duplicate rows

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Paul Marks[_2_] Paul Marks[_2_] is offline

Paul Marks[_2_] is offline

external usenet poster

Posts: 1

Default

duplicate rows

Robert

Please send a blank email to

I will send you a demo s/s

With Kind Regards

Paul

"robert morris" wrote:

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

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

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Duplicate rows into new rows based on row value	Tom	Excel Worksheet Functions	5	March 29th 08 05:32 PM
duplicate rows	Gary Reger	Excel Discussion (Misc queries)	0	June 15th 06 01:13 AM
Duplicate rows	[email protected]	Excel Worksheet Functions	5	December 1st 05 03:28 PM
Duplicate Rows	instauratio	Excel Discussion (Misc queries)	1	June 6th 05 08:36 PM
Duplicate Rows	TO	Excel Worksheet Functions	2	November 12th 04 06:55 PM

All times are GMT +1. The time now is 10:33 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement