duplicate rows delete

amna77 · May 16th, 2002, 09:36 AM

Hi there,
Is there any way that you can delete duplicate rows.
like if column A has duplicate index numbers then delete that entire row.
1 A b
2 C A
2 D a
3 A b
like if I run macro then it should delete row 2, becasue thats i have twice.
Any idea?
Thanks

Tom Schreiner · May 16th, 2002, 09:54 AM

Hi Amna.
There are many exmples to help you on this board. Do a search.
Tom

amna77 · May 16th, 2002, 09:59 AM

Thanks, i got it

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 09:36 AM	#1
amna77 Board Regular Join Date: May 2002 Posts: 251	Hi there, Is there any way that you can delete duplicate rows. like if column A has duplicate index numbers then delete that entire row. 1 A b 2 C A 2 D a 3 A b like if I run macro then it should delete row 2, becasue thats i have twice. Any idea? Thanks

May 16th, 2002, 09:54 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Amna. There are many exmples to help you on this board. Do a search. Tom

May 16th, 2002, 09:59 AM	#3
amna77 Board Regular Join Date: May 2002 Posts: 251	Thanks, i got it