Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards
Sorry for the repost, but I kinda thought someone would know the answer. My
question was; "can wildcards (* ~) be used in formulas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards
I didn't think so but someone may know a way to do it. If you post an
example of what you are trying to do someone will surely have a good solution or two. "italiavb" wrote: Sorry for the repost, but I kinda thought someone would know the answer. My question was; "can wildcards (* ~) be used in formulas? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards
Sorry, I didn't see your first post "...Say to count mulitple rows where cells
that begin with th same number or letter?" I found an example of SUMPRODUCT and made it work to count the number of rows that have cells in column "A" that start with the letter "A". My knowledge of SUMPRODUCT is very limited but you can maybe try it =SUMPRODUCT(--(LEFT(A1:A10,1)="A"),--(A1:A10<"")) "italiavb" wrote: Sorry for the repost, but I kinda thought someone would know the answer. My question was; "can wildcards (* ~) be used in formulas? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards
This is a very good source of examples on SUMPRODUCT
http://www.xldynamic.com/source/xld....T.html#classic "Charlie" wrote: Sorry, I didn't see your first post "...Say to count mulitple rows where cells that begin with th same number or letter?" I found an example of SUMPRODUCT and made it work to count the number of rows that have cells in column "A" that start with the letter "A". My knowledge of SUMPRODUCT is very limited but you can maybe try it =SUMPRODUCT(--(LEFT(A1:A10,1)="A"),--(A1:A10<"")) "italiavb" wrote: Sorry for the repost, but I kinda thought someone would know the answer. My question was; "can wildcards (* ~) be used in formulas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcards in RTD | Excel Discussion (Misc queries) | |||
Use wildcards | Excel Discussion (Misc queries) | |||
wildcards in vba | Excel Discussion (Misc queries) | |||
Wildcards | Excel Programming | |||
Wildcards | Excel Programming |