Hi there,
This has already been posted in the free section, with no hits, so just linking back to original post for reference: http://www.ozgrid.com/forum/showthread.php?t=170361
I am aware of how to accomplish a seudo "minif's"/"maxif's" calculation using an array formula and nested if statements. However, I work with a few other people in the office who are not as familiar or comfortable with this type of formula, but they could benefit from the functionality of having a simplified UDF where they could pass in criteria and criteria ranges (guessing with a ParamArray as the number of criteria would have to be flexible). Also, would need to have the comparitive logic be flexible in the sense that one argument could be where the range is A:A, and the criteria is = value in a cell (i.e. B2) OR same range, but criteria is <> 0.
Also what would be helpful is the ability to declare the return range to be optionally different than the lookup range. I.e. If I have a list of companys in column A, and a list of prices in column B, the option to either return the min/max value, OR the corresponding company in column A for the min value would be great.
And...now that I'm putting this all on paper, the ability to use Small/large, rather than Min/max would be preferrable, as occasionally the user may want the nth smallest/largest return etc. So being able to select what small/large value as an argument (i.e. return 1st small, 2nd small etc.).
Thanks,