In Excell-2000, database how do you extract unique records
 

From a database of columns A to K, how do you "extract" unique records from
column C and corresponding lowest value from column K. A sample spreadsheet
would he helpful and appreciated. - Brian

In Excell-2000, database how do you extract unique records
 

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

In Excell-2000, database how do you extract unique records
 

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

In Excell-2000, database how do you extract unique records
 

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

In Excell-2000, database how do you extract unique records
 

Leave out any headers in the criteria range, in C4 use

=COUNTIF($C$9:$C$190,C9)<=1

assuming C87 is a header and C9 is the first data cell, leave D blank and in
E4 put

=E9=MIN($E$9:$E$195)


then use $C$3:$E$4 as criteria



--
Regards,

Peo Sjoblom

(No private emails please)


"bgpereira" wrote in message
...
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

In Excell-2000, database how do you extract unique records
 

Oops! the MIN formula range should of course be E9:E190

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" wrote in message
...
Leave out any headers in the criteria range, in C4 use

=COUNTIF($C$9:$C$190,C9)<=1

assuming C87 is a header and C9 is the first data cell, leave D blank and
in E4 put

=E9=MIN($E$9:$E$195)


then use $C$3:$E$4 as criteria



--
Regards,

Peo Sjoblom

(No private emails please)


"bgpereira" wrote in message
...
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