Excel has built in functions such as COUNTIF(range, criteria) and SUMIF(range, criteria, sum_range). This project will deliver the VBA code for 2 user defined functions MinIf(Check_Range, Criteria, Data_Range) and MaxIf. Each function should accept ranges and a criteria, similar to SumIf and operate like SumIf except return the Min or Max. Ideally the “Criteria?? will allow for any syntax that returns true/false. I am open to how this should be supplied. One example is to use a single-character token, such as $, to represent a numerical value. Examples would be $>3; And( $<10, $>5); And( $ <=10, $ >3) OR ($ = [url removed, login to view]). Ideally the function would work like SumIf in that the criteria could be supplied with cell references. For example "="&TEXT(B23,"0") checks the check range is equal to the number from B23. This requested function might use something like $ = B23. I am open to alternative ways to accomplish the criteria specification. Only the *First* column matters. If Check_Range is R5C2:R15C12 and Data_Range is R27C22:R29C56, use R5C2:R15C2 and R5C22:R15C22. The program should also accept an entire column, such as C2:C2. The speed should be reasonably fast, no more than 4 times the execution time of SumIf with the same arguments. See posted example file for illustration of what I want. I would also appreciate any suggestions for improvements in the definition.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Any of the recent Excel Macro languages, especially Excel 2003, Excel 2000.