Thank you, Ron, this looks like a very promising solution. However, I am
surprised that Microsoft has not provided a standard function of this
nature. The function has many common uses in data analysis including data
summarization, statistics, accounting, etcetera.

Thank You

**************
"Ron Rosenfeld" wrote in message
...
On Fri, 11 Jan 2008 17:18:12 -0700, "Blue Max"
wrote:

We need to extract the unique values from a range and have them copied to
another range. However, we are looking for a solution that will
transparently keep the unique destination range values updated as the
source
range values change. Is this possible?

Is there some formula or array formula that will extract the unique values
from another range and keep them updated as they change? If not, is there
a
simple macro that could perform the job and be automatically triggered by
cell edits to the source range?

Our goal is to extract the unique account numbers from a large list of
transactions and then summarize the transaction subtotals for any given
account number. We are open to any ideas, thank you.


You could download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/english/index.html

Then you can use this formula:

=INDEX(UNIQUEVALUES(Source_range,1),ROWS($1:1))

and then fill down as far (or further) than necessary.

You can then use a SUMIF using the above cell for the criteria to get your
subtotals.
--ron