 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Counting 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! Post the formula that you are using now that counts all cases  SignatureRegards, Peo Sjoblom > 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! 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*") > Post the formula that you are using now that counts all cases > > > 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! Try =SUMPRODUCT(--(EXACT(LEFT(B4:B7),"Y"))) SignatureRegards, Peo Sjoblom > 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 [quoted text clipped - 11 lines] >> > I'm >> > using excel 2007. Thanks! Thanks for trying... unfortunately when using the formula I got a REF! message. Any other suggestion? > Try > [quoted text clipped - 15 lines] > >> > I'm > >> > using excel 2007. Thanks! 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 SignatureRegards, Peo Sjoblom > Thanks for trying... unfortunately when using the formula I got a REF! > message. Any other suggestion? [quoted text clipped - 18 lines] >> >> > I'm >> >> > using excel 2007. Thanks! You were correct.... I copied the formula incorrectly. Thank you!!! > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.