Hey all, could use a little help on these functions. Currently, I'm trying to determine the max and min based on specific criteria. So my formula is (for example)
=DMIN('Sheet1'!$A$1:$AB$543,"Resolution Time",S57:T58)
I have two criteria Type and User and I want to know the min for TYPE R&R - P where the User equals a specific individual. The problem I'm running in to is that there is a type called R&R - Process that the formula is picking up. So I'm trying to determine how to get the formula to min ONLY R&R - P and NOT give me the min for R&R - P AND R&R - Process.
Any help would be appreciated!
=DMIN('Sheet1'!$A$1:$AB$543,"Resolution Time",S57:T58)
I have two criteria Type and User and I want to know the min for TYPE R&R - P where the User equals a specific individual. The problem I'm running in to is that there is a type called R&R - Process that the formula is picking up. So I'm trying to determine how to get the formula to min ONLY R&R - P and NOT give me the min for R&R - P AND R&R - Process.
Any help would be appreciated!
