Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"LucyB4God" wrote in message
...
Max:
Again thank you for all your help. I was so stumped and it was a
tremendous
help in getting me to the right place. Last night I ended up tweaking
your
array formulas for the columns and adding a IF statement. I see it is
very
close to your recommendation and the good news it worked.
MIN(IF((A$16:A$27=E15)*(C$16:C$27=G15),(IF(B$16:B$ 270,B$16:B27)))) I
will
remember in the future the second IF is not needed.
Have a great day.
--
LB