View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
erhan erhan is offline
external usenet poster
 
Posts: 6
Default calculate min in col B subject to text in col A

I need to calculate the min value in col A subject to text in column B ie;

A B
1 Product Price
2 pen 0.50
3 paper 0.70
4 pen 0.20

I cannot use DMIN because I need to do this calc in a different list, and i
am batteling with the criteria section of this function as I cannot refer to
two rows for header and criteria, I would like to specify criteria as -
"product"=A2 - for instance.

Please Help