| View previous topic :: View next topic |
| Author |
Message |
utm1996
General User
Joined: 25 Jul 2011
Posts: 45
|
 Posted: Tue Jul 17, 2012 8:33 am Post subject: [solved] data sort / filter by partial number |
 |
|
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 |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
| Posted: Tue Jul 17, 2012 4:35 pm Post subject: |
|
|
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 |
|
|
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
| Posted: Tue Jul 17, 2012 8:14 pm Post subject: |
|
|
Hallo
→Data→Filter→Standardfilter:
with 'value' ..-..-[78][0-9]{2}-...
→Button: "More".. [x]regular Expression
Karo |
|
| Back to top |
|
|
utm1996
General User
Joined: 25 Jul 2011
Posts: 45
|
| Posted: Wed Jul 18, 2012 6:47 am Post subject: |
|
|
Ozzie,
That worked splendidly! Thanks!
_________________
------------
OOo 3.3
------------ |
|
| Back to top |
|
|
|
