VB function for Excel

Closed

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 ($ = [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.

## 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: Engineering, MySQL, PHP, Software Architecture, Software Testing, Visual Basic

See more: work made for hire definition, work for hire definition, vba coder for hire, return to work matters, php function for, number function, min range, illustration work for hire, functions in excel vba code, function number, excel user defined function, excel specification, excel macro how to, definition of work for hire, character for hire, cell for hire, what is vba in excel, what is macro in excel, vb in excel, illustration sites, web illustration for, visual basic form excel, vba excel macro, vba code excel, vb excel

Project ID: #3483997

Awarded to:

harfang

See private message.

$17 USD in 30 days
(1 Review)
0.5

8 freelancers are bidding on average $21 for this job

pShankar2

See private message.

$17 USD in 30 days
(406 Reviews)
7.1
zereksvw

See private message.

$68 USD in 30 days
(32 Reviews)
4.8
softwareprabhu

See private message.

$17 USD in 30 days
(15 Reviews)
4.5
doesvw

See private message.

$11.05 USD in 30 days
(40 Reviews)
4.0
annajiat

See private message.

$17 USD in 30 days
(36 Reviews)
3.8
newmenvw

See private message.

$8.5 USD in 30 days
(4 Reviews)
2.1
vpetrovic

See private message.

$8.5 USD in 30 days
(2 Reviews)
1.3