Hi Pete:

I am using advanced filter. What do I put in Cell C4 in the CRIETERIA range
to Extract unique records from Column C ; the corresponding lowest value
database formula in Crieteria Range Cell E4 would be =DMIN(DATA,5,A3:E4)

CRIETETRIA Range A3:E4
DATA range A8:E190
EXTRACT range A195:E195

Thanks
Brian Pereira





"Pete" wrote:

You can extract unique records by using advanced filter - you have the
option of filtering in place or copying the extracted records to
another location. If you want to find the lowest value in column K use
the =MIN( ) function.

Pete