Zack
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I avoid DMIN, DMAX, etc like the plague :)
.. 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
Change F and G to the columns you want to work with, and $12-$15 to the range of rows
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
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
ASKER