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

deleting duplicated cells in a list via advanced autofilter?
 

Oooh. I wouldn't delete that info. It could make life easier when you're doing
other stuff (autofilter/charts/pivottables).

But you could hide the duplicates so that it looks like they're not the
http://www.contextures.com/xlCondFor...html#Duplicate



petevang wrote:

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

--

Dave Peterson