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!