Jun 27 2022 12:22 PM - last edited on Nov 09 2023 11:09 AM by RecycleBin_Rob
Jun 27 2022 12:22 PM - last edited on Nov 09 2023 11:09 AM by RecycleBin_Rob
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'm formatting the code wrong or if its another way I need to code it in VBA.
I figured out the formula format for the command but I want to run it in VBA, the formula format is the following:
Any help would be greatly appreciated, thanks!
Jun 27 2022 12:26 PM
Instead of Application.WorksheetFunction.Evaluate, use Application.WorksheetFunction.MinIfs or shorter, Application.MinIfs
Jun 27 2022 12:28 PM
Jun 27 2022 12:32 PM
Is Data the name of the worksheet? If so, change Data to Worksheets("Data")
Jun 27 2022 12:37 PM