excel question
.......
Joined: Jun 2002
Posts: 522,629
Likes: 0
From: noobtown
why would you have duplicates in rows?
__________________
94 Chevy Blazer - brother crashed.
94 2dr accord - h22 swap, rear ended.
03 1.8 gti - waiting for her bag of chips.
:crazyr: :slap: :hsughr: :nec: :madr:
94 Chevy Blazer - brother crashed.
94 2dr accord - h22 swap, rear ended.
03 1.8 gti - waiting for her bag of chips.
:crazyr: :slap: :hsughr: :nec: :madr:
Thread Starter
Senior Member
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
because my supervisor gave me a spreadsheet that she had been working on
they want me to take over and it has dupes
edit: or let me make it clear:
i mean rows that HAVE duplicates
they want me to take over and it has dupes
edit: or let me make it clear:
i mean rows that HAVE duplicates
h:
BOOM goes the dynamite!
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
you might try this if you just want to delete the duplicate rows. note that each row has to be a complete duplicate.
http://office.microsoft.com/en-us/as...346261033.aspx
http://office.microsoft.com/en-us/as...346261033.aspx
nelson rules
Joined: Sep 2001
Posts: 36,124
Likes: 0
From: the best coast
Originally Posted by Grifter
one more:
is there a way to merge 2 columns?
the opposite of text to columns
is there a way to merge 2 columns?
the opposite of text to columns
__________________
no sig
no sig