Automatically extracting unique values
On Jan 13, 1:44 am, Ron Rosenfeld wrote:
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
Hi,
I have downloaded this extra functions package. I want to display
unique values in the drop down list. But when I use UNIQUEVALUES()
function in the data validation it gives me error "You may not use
references to other worksheets or workbooks for Data Validation
criteria."
Help!!
|