What's the problem using AdvancedFilter? Right tool for the job, IMO.
--
Regards
Dave Hawley
www.ozgrid.com
"eva cheng" wrote in message
...
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