View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
petevang
 
Posts: n/a
Default deleting duplicated cells in a list via advanced autofilter?


I have a list which I would like to filter and deleted duplicated
records.
A1: A250= account numbers
B1:""= values
C1:"" = loan balances
D1:"" = notes

I'd like to be able to delete the duplicate account numbers but still
show the value, loan balances, and notes that belong to the accounts.
Can anyone help. Thanks. Pete:)


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=491461