Results 1 to 9 of 9

Identify spare numbers within a fixed range

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Red face Identify spare numbers within a fixed range


    A part of my job requires me to identify spare telephone numbers within a spreadsheet from a fixed range. ie the range allocated may be 0191 12200 to 0191 12800. I then need to physically scroll through 600 numbers picking out any spares from within that spreadsheet.
    Is it possible to run a query to identify numbers from the allocated range not contained within a spreadsheet?
    And if so can anyone give me any pointers on where to start. As you can imagine this is a pain in the backside part of my job.
    Any advice would be greatly appreciated
    Last edited by ste001; 08-25-2009 at 03:25 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1