View Single Post
  #1  
Old January 9th, 2008, 10:26 PM posted to microsoft.public.excel.misc
Brandy
external usenet poster
 
Posts: 113
Default Finding Multiple Entries & Deleting All but One

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?