Hello - I have filtered a list of data to show only unique records, by
using the Advanced Filter > Unique Records Only option.

However, now I want to remove the filter to show the entire list
(including the duplicate records), does anyone know how I can
accomplish this?

Thanks for any suggestions.

Select a cell in the filtered list then goto Data>Filter>Show All

--
Biff
Microsoft Excel MVP


"Dave K" <fred.sheriff@gmail.com> wrote in message
news:4ae7203d-3a5f-4129-8918-a1bf58415207@27g2000hsf.googlegroups.com...
> Hello - I have filtered a list of data to show only unique records, by
> using the Advanced Filter > Unique Records Only option.
>
> However, now I want to remove the filter to show the entire list
> (including the duplicate records), does anyone know how I can
> accomplish this?
>
> Thanks for any suggestions.