Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help to Create Excel Function using VBA to analyze data
I am trying to create a function using Excel VBA that looks at each argument
and does validation of the argument to determine whether or not to include the argument in the min function. The validation process should exclude arguments that: Argument = 0 Argument is text Argument is an error If the all the arguments fail the validation, it should return a text message ie €śItem not bid€ť otherwise it should return the result of the min value of the arguments that pass the validation process. Any help would be much appreciated. I also want to create a function the works similar using €śSmall€ť. Thanks, bob Function MinPrice(ParamArray arglist() As Variant) As Double For Each arg In arglist MinPrice = WorksheetFunction.Min(arglist) Next arg End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Using "Find" function in Excel 2000, edit data without closing Fin | Excel Discussion (Misc queries) | |||
Does Excel 2000 have the "List" data function like in Excel 2003 | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Can you use the validate function in a data form in Excel? | Excel Worksheet Functions |