LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ramki
 
Posts: n/a
Default passing arrays to user defined functions

hope it is easy one
can any one help me in this regard
how to pass arrays to userdefined functions like
sum(A3:A10) -- my_fun(A3:A10) and how to use those values in the function
that i write?

one more thing is

if i have a list of data(numbers) and i have to count the numbers that fall
in a given range like

if i have 70 45 84 96 85 74 12 36 45 i have to count the number is more
than 50 and numbers less than 50.

is there any function for this.
please help me in this regard

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attaching a particular user defined function to cust button Ajay Excel Discussion (Misc queries) 3 February 23rd 05 08:29 AM
user defined date [email protected] Excel Worksheet Functions 1 January 21st 05 08:57 PM
user defined formats for small numbers Anette Excel Discussion (Misc queries) 1 January 7th 05 04:59 PM
User defined charts- font size too small Bill B Charts and Charting in Excel 1 December 30th 04 06:23 PM
how to move user defined function Grant Excel Worksheet Functions 1 November 17th 04 06:38 PM


All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"