Formula to report unique records from database

[Ed Hansberry, MS-MVP/Mobile Devices]

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.
--
__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? -

 

[Pete_UK]

Hi Ed,

have you tried a Google search of the Excel groups for Unique Values
Formula? Lots of hits for further reading.

Hope this helps.

Pete

 

[Pete_UK]

Hi Ed,

have you tried a Google search of the Excel groups for Unique Values
Formula? Lots of hits for further reading.

Hope this helps.

Pete

 

[Peo Sjoblom]

Hi Ed,

there is an example here (there is the possibility to download an example as
well)

http://nwexcelsolutions.com/advanced_function_page.htm


It's the first example, note that array formulas tend to degrade performance


--


Regards,


Peo Sjoblom





"Ed Hansberry, MS-MVP/Mobile Devices"

 

[Ed Hansberry, MS-MVP/Mobile Devices]

Hi Ed,

there is an example here (there is the possibility to download an example as
well)

http://nwexcelsolutions.com/advanced_function_page.htm


It's the first example, note that array formulas tend to degrade performance

Thanks! I'll have to play with that.
--
__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? -