Re: excel duplicates problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 21:11:33 -0000

Just delete them all and reselect the correct ranges using the range select
buttons in the dialog box. 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
              Sys Spec - Win XP Pro /  XL 97/00/02/03
----------------------------------------------------------------------------
                  It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:B76B3CCF-72BD-46B7-9FF1-F9443BC23D2C@microsoft.com...
> I'm trying to eliminate duplicates from an imported list and the advanced
> step has me stuck.  When I get to the advanced filter, there are some word
> figures in the "list range".  something like "$A$$660:$0$$" I click "ok"
and
> it comes up with an error.  What am I doing wrong?
>
> thanks
> Jason
Quantcast