Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
I'm working with columns and/or rows containing both upper and lower case
letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
Post the formula that you are using now that counts all cases
-- Regards, Peo Sjoblom "TJA" wrote in message ... I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
This is the current formula... It will count only the letter "y" with
wildcard, regardless if it is upper or lower case. I would like it to count only uppercase with wildcard. Thanks for your response. =COUNTIF(B4:B7,"y*") "Peo Sjoblom" wrote: Post the formula that you are using now that counts all cases -- Regards, Peo Sjoblom "TJA" wrote in message ... I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
Try
=SUMPRODUCT(--(EXACT(LEFT(B4:B7),"Y"))) -- Regards, Peo Sjoblom "TJA" wrote in message ... This is the current formula... It will count only the letter "y" with wildcard, regardless if it is upper or lower case. I would like it to count only uppercase with wildcard. Thanks for your response. =COUNTIF(B4:B7,"y*") "Peo Sjoblom" wrote: Post the formula that you are using now that counts all cases -- Regards, Peo Sjoblom "TJA" wrote in message ... I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
Thanks for trying... unfortunately when using the formula I got a REF!
message. Any other suggestion? "Peo Sjoblom" wrote: Try =SUMPRODUCT(--(EXACT(LEFT(B4:B7),"Y"))) -- Regards, Peo Sjoblom "TJA" wrote in message ... This is the current formula... It will count only the letter "y" with wildcard, regardless if it is upper or lower case. I would like it to count only uppercase with wildcard. Thanks for your response. =COUNTIF(B4:B7,"y*") "Peo Sjoblom" wrote: Post the formula that you are using now that counts all cases -- Regards, Peo Sjoblom "TJA" wrote in message ... I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
You must have copied it incorrectly, it certainly works. REF errors come
from when you reference a cell that doesn't exist for instance if you reference A1 and then you delete the first row. There is no way that formula can return a REF error if pasted correctly, besides it returns the same result as the formula you posted except that it counts strings that start with uppercase Y -- Regards, Peo Sjoblom "TJA" wrote in message ... Thanks for trying... unfortunately when using the formula I got a REF! message. Any other suggestion? "Peo Sjoblom" wrote: Try =SUMPRODUCT(--(EXACT(LEFT(B4:B7),"Y"))) -- Regards, Peo Sjoblom "TJA" wrote in message ... This is the current formula... It will count only the letter "y" with wildcard, regardless if it is upper or lower case. I would like it to count only uppercase with wildcard. Thanks for your response. =COUNTIF(B4:B7,"y*") "Peo Sjoblom" wrote: Post the formula that you are using now that counts all cases -- Regards, Peo Sjoblom "TJA" wrote in message ... I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting only uppercase letters with wildcard in column/row
You were correct.... I copied the formula incorrectly. Thank you!!!
"TJA" wrote: I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, can you change uppercase letters to lowercase | New Users to Excel | |||
excel: count uppercase letters in a cell | Excel Worksheet Functions | |||
Why do all my cells automatically turn into uppercase letters? | Excel Discussion (Misc queries) | |||
CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS? | Excel Discussion (Misc queries) | |||
Counting Letters in a Column | Excel Discussion (Misc queries) |