This is an excel question as:
I got a field with numbers...(1 to 10000)
I like to extract numbers ending with 22,35,49,51,67
so how to do it..
My try..
Data>auto sorting> condition..select ending with 22 or ending with 35.( only two rows to selec I try to do it first)
reslt no matching..
I also try to use *22, *35
still no result........
Peter J. Boettcher posted this at 14:02 — 11th January 2002.
They have: 812 posts
Joined: Feb 2000
I'm not really an excel expert. Did you try using filters?
uatt posted this at 14:23 — 11th January 2002.
They have: 27 posts
Joined: Jan 2002
Hi peter
what is filter? and where to click it...
Peter J. Boettcher posted this at 14:37 — 11th January 2002.
They have: 812 posts
Joined: Feb 2000
It depends on what version of Excel you're using, but in Excel 2000 its in the data menu under sort.
PJ | Are we there yet?
pjboettcher.com
uatt posted this at 14:50 — 11th January 2002.
They have: 27 posts
Joined: Jan 2002
I found no filter option there...
Peter J. Boettcher posted this at 15:02 — 11th January 2002.
They have: 812 posts
Joined: Feb 2000
Try using the Excel help menu, and search on filter, it should tell you how to use it and where it is.
PJ | Are we there yet?
pjboettcher.com
uatt posted this at 15:18 — 11th January 2002.
They have: 27 posts
Joined: Jan 2002
Sorry I mislead the word filter..
Actually I do it with filter
filter>auto filter
an arrow appear on cell column
I click self-setting(something like that as I use chinese version of excel)
It appears two conditional rows
first row.I chose
condition ending with *22
or
second row
condition ending with *35
now result appear...
This is exactly what I mean with my first post..
sorry for my poor English..