| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to create function
How can I create a function to pick out a selection of numbers that is
greater than 900,000,000? How can I create a function to pick out the second letter of a last name if the second letter is an "f"? How can I create a function to pick out a name if the name does not contain a lastname, first initial of the first name? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to create function
For the first function, you could write something similar to the following:
public function numFind(rng as range) for each cl in rng.cells if cl.value 900000000 then iCount=iCount+1 end if next numFind = iCount end function -- http://HelpExcel.com "bsatstudent5" wrote: How can I create a function to pick out a selection of numbers that is greater than 900,000,000? How can I create a function to pick out the second letter of a last name if the second letter is an "f"? How can I create a function to pick out a name if the name does not contain a lastname, first initial of the first name? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to create function
For the first question: =COUNTIF(A1:A100,"900000000")
For the second question: =IF(LEFT(A1,2)="f",LEFT(A1,2),"") I don't understand the third question. Dave -- Brevity is the soul of wit. "galimi" wrote: For the first function, you could write something similar to the following: public function numFind(rng as range) for each cl in rng.cells if cl.value 900000000 then iCount=iCount+1 end if next numFind = iCount end function -- http://HelpExcel.com "bsatstudent5" wrote: How can I create a function to pick out a selection of numbers that is greater than 900,000,000? How can I create a function to pick out the second letter of a last name if the second letter is an "f"? How can I create a function to pick out a name if the name does not contain a lastname, first initial of the first name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create data tables and is there a payback period function | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Create a function wher last digit is always set | Excel Worksheet Functions | |||
| How to create a formula for this function. | Excel Worksheet Functions | |||
Hybrid Mode
