Posted to microsoft.public.excel.newusers

Dave[_11_] Dave[_11_] is offline

external usenet poster

Posts: 41

Help on a task

Hi Gang:

Need some help on a query I have a long list of 3000 numbers. like
this

91290007957
91290007977
91290008257
91400000000
92400000000
01500000000
91401039801
90550000000
00160000000
91401050593

I want to sort off any numbers that the 2nd and 3rd numbers are
greater then 12.
Example would be:
91400000000
92400000000
01500000000

then of those that are left I would sort off any that the 4th number
was not an 8 or 9

90550000000
00160000000

Sincerely,

thanks in advance

Dave

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Task Bar Problem	basketcase63	Excel Discussion (Misc queries)	2	September 4th 06 04:04 PM
First ever task	LIGHT USER	Excel Discussion (Misc queries)	4	March 23rd 06 09:25 PM
convertTask 1.1, Task 11.1 which come one below the other into no	chandra	Excel Discussion (Misc queries)	2	March 22nd 06 04:30 PM
Task Pane	Kevin	New Users to Excel	0	March 23rd 05 05:21 PM
Task bar	PghPatti	Excel Discussion (Misc queries)	4	February 13th 05 02:05 AM

All times are GMT +1. The time now is 04:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us