View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete Derkowski Pete Derkowski is offline
external usenet poster
 
Posts: 11
Default Min of range where other col has a value

Hi, I'm trying to pull the min number from a col, where the value in another
col is defined.
ie.
A 5
B 2
A 2
C 7
A 10
B 1
C 5

I need to pull the min for A. I looked up DMIN but the Help doesn't do my
any good. Thought combo of MIN and SUMPRODUCT might work but can't get the
syntax right.

Anyone know how to do this?