Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Unique Records from two lists | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
filtering for unique records | Excel Discussion (Misc queries) | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) |