OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Formula to search certain character...

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
burt
General User
General User


Joined: 17 Jan 2011
Posts: 12
Location: philippines

PostPosted: Wed Jan 04, 2012 7:04 am    Post subject: Formula to search certain character... Reply with quote

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
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Wed Jan 04, 2012 8:57 am    Post subject: Reply with quote

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUNTIF_function
_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
burt
General User
General User


Joined: 17 Jan 2011
Posts: 12
Location: philippines

PostPosted: Wed Jan 04, 2012 3:54 pm    Post subject: Reply with quote

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
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 400
Location: victoria

PostPosted: Wed Jan 04, 2012 9:36 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group