sorting of an excel number column
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.
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.
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..
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.