Automatically extracting unique values
On Sat, 12 Jan 2008 12:39:03 -0700, "Blue Max" wrote:
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.
There are other solutions possible.
There are complex formulas which can extract unique values from a list, but, so
long as your strings are <256 characters, Longre's solution is simpler to
implement.
You could also set up a Pivot Table, but to make it completely automatic, you
would also need to set up an event-triggered macro to refresh the pivot table
when ever the source data changes.
Best,
--ron
|