I am trying to use all formula's instead of pivotables
on large data sources.

How large is large? More than a few hundred rows?

Formulas to extract unique records are calculation intensive and would slow
things down on "large" amounts of data.

You could probably use a bunch of helper columns that might help speed
things up but then you end up with a bunch of helper columns!

Also, you need to be a bit more specific. Do you want to extract the unique
records from a single column/row or do you want to extract multiple
column/rows of records based on the unique items in a single column/row?

--
Biff
Microsoft Excel MVP


"Keithlearn" wrote in message
...
I am trying to make a report a little more user friendly for a novice excel
user, and I am trying to use all formula's instead of pivotables on large
data sources. Is there a formula that will pull unique records out of a
list
of customer #'s as an example without having to use auto filter which
would
then require more manual intervention. I am then using sumproducts using
the
customer number to create the report.