| View previous topic :: View next topic |
| Author |
Message |
burt
General User
Joined: 17 Jan 2011
Posts: 12
Location: philippines
|
 Posted: Wed Jan 04, 2012 7:04 am Post subject: Formula to search certain character... |
 |
|
Need to search certain characters from a serial code...
example... serial code is BURT001234
i need to search "BURT" so that i can count how many under this category...
thanks!
Last edited by burt on Wed Jan 04, 2012 6:00 pm; edited 2 times in total |
|
| Back to top |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
|
| Back to top |
|
|
burt
General User
Joined: 17 Jan 2011
Posts: 12
Location: philippines
|
| Posted: Wed Jan 04, 2012 3:54 pm Post subject: |
|
|
This is what i did:
=COUNTIF(Retail.B14:b350;"BURT")
but then it does not read.. comes out 0. The data to be read comes from another sheet of the same file which is Retail. the serial numbers searched are like this:
BURT1234
BURT2345
BURT6789
TON1234
TON3456
TON5678
what i want to count id how many "BURT" are there.
need help badly for a newbie... thanks again. |
|
| Back to top |
|
|
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
| Posted: Wed Jan 04, 2012 9:36 pm Post subject: |
|
|
try
| Code: | | =COUNTIF(Retail.B14:b350;"BURT.*") |
your formula is looking for BURT as the entire content of the cell
(BURT period asterisk) - looks for burt and anything else after burt
(period asterisk) - should also be added before BURT if there are any occassions where there are any odd characters appearing at the start of the cell contents
if this has solved your problem please add 'solved' to the title of this thread by editing your first post |
|
| Back to top |
|
|
|
