I need a function that will report unique records from a
database. It needs to do pretty much what the "Advanced Filter"
command does when it copies data to a new area and the "unique"
box is checked.

I much prefer VBA functions or array formulas to VBA code to
accomplish this. This is for a set of financial statements and
they combine multiple companies. Each time a brand is selected, I
want to be able to show on the financial statements the companies
that are included in a particular report.

A complete last resort would be to use VBA code to do the
Advanced Filter command. I think I would rather use a DAO query
to go back to the Access Database where the data is stored and
run a quick Select query before I fooled with the Advanced
Filter.

Any ideas on how to accomplish this in Excel so it is dynamic (ie
formula of some sort) versus having to trigger code each time I
change the view?

Excel 2007.