| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CUSTOM FUNCTION DESIRED
Hello every1!
Can anyone devise me a piece of code to formulate a custom function like: MyRate(Array1,Array2,Criteria) To work for a function like: =SUMPRODUCT(--(A1:A20="A"),B1:B20,C1:C20)/SUMPRODUCT(--(A1:A20="A"),B1:B20) As: MyRate(A1:A20,B1:B20,"A") All your assistance and expertise shall be highly obliged. Thanx in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| which function can get the desired result? | Excel Worksheet Functions | |||
| IRR desired return | Excel Worksheet Functions | |||
| Simplicity is Desired | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Linking across worksheets not working as desired | Excel Worksheet Functions | |||
Threaded Mode
