Forum Discussion
MinIfs Function
Hello, I'm having trouble formatting the minifs statement in VBA. I want the code to look for the minimum value in a data table with two criteria's applied. This what I have so far, I'm not sure if I...
Instead of Application.WorksheetFunction.Evaluate, use Application.WorksheetFunction.MinIfs or shorter, Application.MinIfs
- Ah haha never mind I figured it out, I was misspelling it the whole time. Thanks!
Is Data the name of the worksheet? If so, change Data to Worksheets("Data")