Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel 2010 data management
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.


Job awarded.

Aug 8, 2011

Job Description

  |  Change History >>


  • Posted: Sun, Aug 07, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Hello, I have a requirement as per below:

1) From an Excel 2010 column of alphanumeric data, strip any alphabetic characters away, leaving only the numeric characters. eg C1234 would become 1234, A6759 would become 6759, BEL2354 would become 2354

2) From the remaining list of numeric characters, sort them in ascending numerical order.

3) From the sorted list, produce a list of the missing numbers within the number range. eg cells containing the numbers 3,4,5,6,8,9,10 - the missing number is 7
Added 7 AUG 2011, 23:37 PM EDT
Hi, the example was just a small sample. We will have large lists up to 2000 numbers at a time. The number ranges will vary, and what we will be wanting is a list of all missing numbers within the number range, of which there could be quite a few.
We want a macro/program written so we can run it as often as we like against the new number set we have loaded into a column.

Sign in or Register to see more

Job ID: 25565929
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Pakistan  |  
Experienced PHP, ASP.Net developer, expertise both in desktop and web application. Expert in database driven application with excellent user...
 4.8   |  Private   |  73 Jobs   |  1 verified credential(s)
Bid ID: 25568334  |  Submitted: Aug 8, 2011 02:01 ET 
Proposal SEALED

 United States  |  
Professional Skills: -Access, Excel, VBA, SQL -Automation -Lead generation, Data mining, High level data entry (using programing techniques)...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 25567388  |  Submitted: Aug 8, 2011 00:33 ET 
Proposal SEALED

 United States
For the past fifteen years my primary focus has been spreadsheet development, initially with the Lotus 123 macro language, and for the past decade...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 25567104  |  Submitted: Aug 8, 2011 00:00 ET 
Proposal SEALED

Good at VBA development for EXCEL,Word,Access, PowerPoint, Outlook. Developed over 200000 lines of code in Visual Basic 6, C#.net, VB.net and other...
 0.0   |  Private   |  0 Jobs
Bid ID: 25566954  |  Submitted: Aug 7, 2011 23:44 ET 
Proposal SEALED

 India  |  
Over the last few years, Ideal Solutions has embarked on the competitive IT environs with an innate ideology of providing end-to-end customized IT...
 5.0   |  Private   |  3 Jobs
Bid ID: 25566535  |  Submitted: Aug 7, 2011 22:59 ET 
Within 1 day

BAI XING      
BAI XING's identity has been verified.  Learn More
 China  |  
Hi-Tech Green software Inc is an authorized software development company well known to home and abroad and operating out of Changchun city of jilin...
 3.1   |  $1,629 Earnings   |  5 Jobs
Bid ID: 25566117  |  Submitted: Aug 7, 2011 22:10 ET 
Proposal SEALED

 United States  |  
Microsoft Excel Trainer / Programmer (20 years of experience)
 0.0   |  Private   |  0 Jobs
Bid ID: 25566056  |  Submitted: Aug 7, 2011 22:03 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »