VB function for Excel

Avg Bid (USD)
Project Budget (USD)
$15 - $20

Project Description:
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 ($ = 6.55). 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.

## Deliverables

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).

## Platform

Any of the recent Excel Macro languages, especially Excel 2003, Excel 2000.

Skills required:
Engineering, MySQL, PHP, Software Architecture, Software Testing, Visual Basic
Additional Files: zRAC_DOC_NameCryptedToProtectYourPrivacy_X2006561962213582728281312424268485065560552702087211178305801415768.zip
Hire j39759
Project posted by:
j39759 United States
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

Hire pShankar2
$ 17
in 30 days
Hire zereksvw
$ 68
in 30 days
Hire softwareprabhu
$ 17
in 30 days
Hire doesvw
$ 11.05
in 30 days
Hire annajiat
$ 17
in 30 days
Hire newmenvw
$ 8.5
in 30 days
Hire vpetrovic
$ 8.5
in 30 days
Hire harfang
$ 17
in 30 days