Thread
:
Finding Multiple Entries & Deleting All but One
View Single Post
#
4
January 9th, 2008, 10:55 PM posted to microsoft.public.excel.misc
Brandy
external usenet poster
Posts: 113
Finding Multiple Entries & Deleting All but One
Yeah, I don't want to delete the rows. I just want to clear the cell for the
second and subsequent cells that match that #.
"TRYING" wrote:
DON: Seems to me Brandy does not want to delete the rows. She only wants to
clear the PO number from the second and subsequent cells. The other 5 rows
for PO # 200205 might contain information different from the first one.
BRANDY: Unless you have a particularly good reason for wanting to remove the
second and subsequent appearance of the same PO #, you might be better off
keeping them.
"Don Guillett" wrote:
Several ways such as
datafilteradvanced filtercopy
or a loop from the bottom that says if the cell above is the same delete the
row.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Brandy" wrote in message
...
I have a large and lengthy spreadsheet. I have one column representing PO
#'s. The spreadsheet is already sorted by PO #s and they are in order. For
instance though, I have 6 lines that are for PO # 200205. I would like to
see
#200205 only on the first line and the next 5 lines not have a PO # listed
at
all. So what kind of command can I type so that it will only show the
first
PO # and delete the rest that match that #? Does that make sense?
Brandy
View Public Profile
View message headers
Find all posts by Brandy
Find all threads started by Brandy