Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 650
  • Last Modified:

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
0
zack4x4
Asked:
zack4x4
1 Solution
 
cyberkiwiCommented:
=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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now