Help with Excel DMIN

Hi - I need some help with Excel DMIN.  Here is a sample from the spreadsheet...

Column F is the Truck (row 12-15 in this example)
Column G is the Ticket # (row 12-15)

Basically I want to conditionally find out the minimum ticket number for each truck.  I can provide separate formulas on separate lines to do each truck I just need the template...

If DMIN isn't the correct function please let me know!

Thanks! Zack
sample.bmp
LVL 4
zack4x4Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
cyberkiwiConnect With a Mentor Commented:
=MIN(IF(F$12:F$15=F12,G$12:G$15,""))

Enter as array formula (ctrl-shift-enter)
0
 
zack4x4Author Commented:
That worked perfectly - thanks!!
0
 
Patrick MatthewsCommented:
I avoid DMIN, DMAX, etc like the plague :)
0
 
cyberkiwiCommented:
.. into H12, then copy down
Change F and G to the columns you want to work with, and $12-$15 to the range of rows
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hi,

the formula would be

=DMIN(F1:G5,"Ticket",I1:I2)

I1 has the value "Truck" I2 has the value ="=T01R"

The required layout is in the attached file.

cheers, teylyn
Book6.xls
0
All Courses

From novice to tech pro — start learning today.