deleting duplicated cells in a list via advanced autofilter?

[petevang]

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

[Dave Peterson]

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 there:
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