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

[solved] data sort / filter by partial number

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


Joined: 25 Jul 2011
Posts: 45

PostPosted: Tue Jul 17, 2012 8:33 am    Post subject: [solved] data sort / filter by partial number Reply with quote

If I have a number in the format xx-xx-xxx-xxx and I want to sort out or color all the numbers where the left set of xxx is between 700 & 899....any thoughts?

the numbering currently is sequential from left to right...
01-01-100-001
01-01-100-002
...
01-01-701-001

Or if you can point me in the direction of a help page, that'll work also.
_________________
------------
OOo 3.3
------------


Last edited by utm1996 on Wed Jul 18, 2012 6:48 am; edited 1 time in total
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 397
Location: victoria

PostPosted: Tue Jul 17, 2012 4:35 pm    Post subject: Reply with quote

perhaps a helper column with this
Code:
=IF(AND(VALUE(MID(A1;7;3))>699;VALUE(MID(A1;7;3))<900);VALUE(MID(A1;7;3));"")

note - it requires that the first two double 'x' columns only contain two characters each, if not, a different formula can be done if this route is suitable.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Tue Jul 17, 2012 8:14 pm    Post subject: Reply with quote

Hallo

→Data→Filter→Standardfilter:
with 'value' ..-..-[78][0-9]{2}-...

→Button: "More".. [x]regular Expression

Karo
Back to top
View user's profile Send private message
utm1996
General User
General User


Joined: 25 Jul 2011
Posts: 45

PostPosted: Wed Jul 18, 2012 6:47 am    Post subject: Reply with quote

Ozzie,
That worked splendidly! Thanks!
_________________
------------
OOo 3.3
------------
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