Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min, dmin, etc
I would like to have a function that was able to recognize the
smallest/largest figure in one cell based on a criteria. For example, let's say I run multiple convenience stores and want to find the lowest price for SKU 12345 in the following table: SKU Price 11111 $3.00 12345 $1.50 12345 $1.51 11112 $0.92 12345 $1.49 My worksheet has a 2nd tab with a list of unique SKUs that are being used and a single column to show the lowest price, and another to show the highest (and the average). I can't seem to get DMIN or any vlookup functions to work. Any advice would be appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min, dmin, etc
Try these array formulas** :
Min: =MIN(IF(A1:A5=12345,B1:B5)) Max: =MAX(IF(A1:A5=12345,B1:B5)) Average: =AVERAGE(IF(A1:A5=12345,B1:B5)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "sduffield" wrote in message ... I would like to have a function that was able to recognize the smallest/largest figure in one cell based on a criteria. For example, let's say I run multiple convenience stores and want to find the lowest price for SKU 12345 in the following table: SKU Price 11111 $3.00 12345 $1.50 12345 $1.51 11112 $0.92 12345 $1.49 My worksheet has a 2nd tab with a list of unique SKUs that are being used and a single column to show the lowest price, and another to show the highest (and the average). I can't seem to get DMIN or any vlookup functions to work. Any advice would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
dmin | Excel Worksheet Functions | |||
DMIN Criteria | Excel Worksheet Functions | |||
MIN or DMIN ? | Excel Worksheet Functions | |||
Function DMIN? | Excel Worksheet Functions |