Have been wrestling with different subs that extract unique values from a
list - immediately upon anything in the source list changing.

First tried putting a Filter Unique Values routine at the worksheet level.
It "made a lot of noise" but didn't accomplish the task.
Think it can be done in this manner, but obviously haven't got the code right.

Then tried various Filter Unique Value routines with Application.Volatile.

Considering what can be done with SUMIFS, COUNTIFS, etc, this seems like it
should be a big priority everywhere.
But can't seem to hit on the right combination of code, and exactly where to
put it.

Does anyone have a tried-and-true proven method for this?

Thanx in advance.
- Mike

Mike,

A sub/function with a change event can DEFINITELY accomplish this.
--
http://www.ExcelHelp.us
(E-Mail Removed)
888-MY-ETHER ext. 01781474



"MikeF" wrote:

> Have been wrestling with different subs that extract unique values from a
> list - immediately upon anything in the source list changing.
>
> First tried putting a Filter Unique Values routine at the worksheet level.
> It "made a lot of noise" but didn't accomplish the task.
> Think it can be done in this manner, but obviously haven't got the code right.
>
> Then tried various Filter Unique Value routines with Application.Volatile.
>
> Considering what can be done with SUMIFS, COUNTIFS, etc, this seems like it
> should be a big priority everywhere.
> But can't seem to hit on the right combination of code, and exactly where to
> put it.
>
> Does anyone have a tried-and-true proven method for this?
>
> Thanx in advance.
> - Mike

Any chance of sharing the appropriate code?
Appreciatively,
- Mike

"galimi" wrote:

> Mike,
>
> A sub/function with a change event can DEFINITELY accomplish this.
> --
> http://www.ExcelHelp.us
> (E-Mail Removed)
> 888-MY-ETHER ext. 01781474
>
>
>
> "MikeF" wrote:
>
> > Have been wrestling with different subs that extract unique values from a
> > list - immediately upon anything in the source list changing.
> >
> > First tried putting a Filter Unique Values routine at the worksheet level.
> > It "made a lot of noise" but didn't accomplish the task.
> > Think it can be done in this manner, but obviously haven't got the code right.
> >
> > Then tried various Filter Unique Value routines with Application.Volatile.
> >
> > Considering what can be done with SUMIFS, COUNTIFS, etc, this seems like it
> > should be a big priority everywhere.
> > But can't seem to hit on the right combination of code, and exactly where to
> > put it.
> >
> > Does anyone have a tried-and-true proven method for this?
> >
> > Thanx in advance.
> > - Mike