| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Begins with"
How can I express the following within a function?
begins with contains ends with |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
It depends what kind of function? Which one are you thinking of?
-- Regards, Peo Sjoblom "Amber" wrote in message ... How can I express the following within a function? begins with contains ends with |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
Amber,
If you mean a UDF then you can use the LIKE function in VBA but you need to be more specific. Mike "Amber" wrote: How can I express the following within a function? begins with contains ends with |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
On May 25, 10:59 am, Amber wrote:
How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
What I am trying to do is do a sumif statement but there are some of the the
line items that I want to not be added. I need to try to figure out how to say that in an expression.... Any help you could give would be great. Thanks Amber " wrote: On May 25, 10:59 am, Amber wrote: How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
Sorry I forgot to add that the items items to exclude would all start
with"600" but are all different. "Amber" wrote: What I am trying to do is do a sumif statement but there are some of the the line items that I want to not be added. I need to try to figure out how to say that in an expression.... Any help you could give would be great. Thanks Amber " wrote: On May 25, 10:59 am, Amber wrote: How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
Maybe something like this:
=SUMPRODUCT(--(LEFT(A1:A10,3)<"600"),B1:B10) Biff "Amber" wrote in message ... What I am trying to do is do a sumif statement but there are some of the the line items that I want to not be added. I need to try to figure out how to say that in an expression.... Any help you could give would be great. Thanks Amber " wrote: On May 25, 10:59 am, Amber wrote: How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
What do A and B Stand for?
"T. Valko" wrote: Maybe something like this: =SUMPRODUCT(--(LEFT(A1:A10,3)<"600"),B1:B10) Biff "Amber" wrote in message ... What I am trying to do is do a sumif statement but there are some of the the line items that I want to not be added. I need to try to figure out how to say that in an expression.... Any help you could give would be great. Thanks Amber " wrote: On May 25, 10:59 am, Amber wrote: How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
Cell references, replace them with the ranges you want to apply this on
-- Regards, Peo Sjoblom "Amber" wrote in message ... What do A and B Stand for? "T. Valko" wrote: Maybe something like this: =SUMPRODUCT(--(LEFT(A1:A10,3)<"600"),B1:B10) Biff "Amber" wrote in message ... What I am trying to do is do a sumif statement but there are some of the the line items that I want to not be added. I need to try to figure out how to say that in an expression.... Any help you could give would be great. Thanks Amber " wrote: On May 25, 10:59 am, Amber wrote: How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
A1:A10 is the range of cells that contain your line items.
B1:B10 is the range to sum. Maybe you need to post a more descriptive explanation. Biff "Amber" wrote in message ... What do A and B Stand for? "T. Valko" wrote: Maybe something like this: =SUMPRODUCT(--(LEFT(A1:A10,3)<"600"),B1:B10) Biff "Amber" wrote in message ... What I am trying to do is do a sumif statement but there are some of the the line items that I want to not be added. I need to try to figure out how to say that in an expression.... Any help you could give would be great. Thanks Amber " wrote: On May 25, 10:59 am, Amber wrote: How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
Like this:
A1 = XXXabcZZZ begins with =LEFT(A1,3)="XXX" contains =ISNUMBER(SEARCH("abc",A1)) ends with =RIGHT(A1,3)="ZZZ" Note that none of these are case sensitive. Biff "Amber" wrote in message ... How can I express the following within a function? begins with contains ends with |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
On May 25, 10:59 am, Amber wrote:
How can I express the following within a function? begins with contains ends with I think you are looking for the LEFT, FIND, and RIGHT functions. Not sure exactly how you want to use these but here's some examples: Does the cell A1 begin with "Bob"? =LEFT(A1,3)="Bob" Does the cell A1 contain "Bob"? =FIND("Bob",A1)0 Does the cell A1 end with "Bob"? =RIGHT(A1,3)="Bob" If you want to refer to another cell, say B1, then it's: =LEFT(A1,LEN(B1))=B1 =FIND(B1,A1)0 =RIGHT(A1,LEN(B1))=B1 cheers, ..o. |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Begins with"
As worksheet functions?
Begins with: =countif(a1,"Amber*")0 contains: =countif(a1,"*amber*")0 ends with: =countif(a1,"*amber")0 Amber wrote: How can I express the following within a function? begins with contains ends with -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write "begins with"? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Sorting text that begins with "the" or "a" | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
