Prev: Excel VB application
Next: Microsoft date and time picker control
From: eva cheng on 30 Apr 2010 00:11
I am using Excel 2003, I have a column of records which may duplicated. How
can I extract the unique records to a list by using a formula not advance
filtering

Thanks
--
eva cheng
From: ozgrid.com on 30 Apr 2010 00:21
What's the problem using AdvancedFilter? Right tool for the job, IMO.


--
Regards
Dave Hawley
www.ozgrid.com
"eva cheng" <evacheng(a)discussions.microsoft.com> wrote in message
news:5D555376-00F0-4CB1-BC2D-966FD9A28C31(a)microsoft.com...
>I am using Excel 2003, I have a column of records which may duplicated. How
> can I extract the unique records to a list by using a formula not advance
> filtering
>
> Thanks
> --
> eva cheng

From: eva cheng on 30 Apr 2010 00:45
As I want the list to be updated automatically (my boss doesn't familiar with
excel) when the records are changed, is it possible to do with a formula or
macro ?

Thanks
--
eva cheng


"eva cheng" wrote:

> I am using Excel 2003, I have a column of records which may duplicated. How
> can I extract the unique records to a list by using a formula not advance
> filtering
>
> Thanks
> --
> eva cheng
From: Dave Peterson on 30 Apr 2010 08:32
If you're ok with a macro, you could record one when you do the advanced filter
with unique records checked.

Then rerun that macro whenever you needed to update that unique list.

eva cheng wrote:
>
> As I want the list to be updated automatically (my boss doesn't familiar with
> excel) when the records are changed, is it possible to do with a formula or
> macro ?
>
> Thanks
> --
> eva cheng
>
> "eva cheng" wrote:
>
> > I am using Excel 2003, I have a column of records which may duplicated. How
> > can I extract the unique records to a list by using a formula not advance
> > filtering
> >
> > Thanks
> > --
> > eva cheng

--

Dave Peterson
 | 
Pages: 1
Prev: Excel VB application
Next: Microsoft date and time picker control