I also think there should be a built-in function (or 2) for extracting
uniques or extracting uniques with a condition. This is a frequently asked
question in these groups. The advanced filter is simple enough to use but
like you point out, it's not dynamic. There are many formula variations to
do this but most, if not all, of those formulas can be described as rather
complex and not easily understood, if at all, by the average user.

Even more useful would be a function to count uniques with conditions.

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Excel2003 ... I am always crunching data where I have repeating records &
I
often use Advance Filter to extract the "Unique" records ... Then I set
formulas in adjacent Cols that will reach back into the data & return the
various values I need crunched.

Above said ... it would be very helpful to have a dynamic formula ...
perhaps something like ... =unique(range, criteria) ... that would simply
change the "Unique" records list when the data in the range is updated.

On 08/09/07 I posted to this board ... "Return Unique Records ... No
Blanks"
... & received a post back from Ragdyer with a formula that works very
well
... Do I understand how it works? Absolutely not, but it works.

Above said ... I think this capability would be so useful that a
simplified
formula would be written to cover it ... I know I am always looking to
crunch
numbers off of "Unique" records ... and to have the "Unique" records
change
as the body of data changes would be awesome ... (Advance Filter does not
do
this)

My "Thanks" to the folks that are intimate with Excel & support these
boards
with all of your guidance ... & again to Ragdyer for another nice bail-out
... Kha