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