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

B

bgpereira

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
 
P

Pete

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
 
B

bgpereira

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
 
B

bgpereira

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
[email protected]
 
P

Peo Sjoblom

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)
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top