Post ProjectBuyersProgrammersFAQForumContactRSS
      MEMBER LOGIN
      SERVICES & FEATURES
  • Post a Project
  • Signup
  • Job Listings
  • Featured Projects
  • Certified Members
  • Top Programmers
  • Affiliate Program
  • RSS Feeds
  •    THE 20 LATEST PROJECTS
    Photo Book Software Needed
    Convert A Word Doc To E-book
    Site Bugs Fixes & Additions
    Simple Vbulletin Hack
    Joomla Enhancements
    Dynamic Search With Results
    Intro Movie 10secs
    Redirect From Root To Subdir..
    Bulk Email/private List
    Writers For Health Insurance
    Prosper Clone
    Auction Type Website
    Myspace Invites 1k Yess
    Sellaband(.)com Clone
    Myspace Invites 1k
    Real Signups Dating Site
    Php - Html Programming
    Authentication For Cd Access
    Index/html Book Program
    I Need An Email List
     
    Project: Excel Unique Value Utility
    ID: 1223396274
    Post Similar ProjectManage Your Project

    PROJECT DETAILS
    Status: Closed (Chosen Programmer: restyler)
    Budget: N/A
    Created: 10/7/2008 at 12:17 EST
    Closed: 10/7/2008 at 15:40 EST
    Project Creator: elijahtechnologies
    Rating: 10.00/10 (3 reviews)
    Description: Hi,
    I have an Excel spreadsheet with two columns each containing lists of files and file paths (e.g. c:\please\helpme.doc). I need a simple way of identifying if the same file path is listed in both Column A and Column B, and if so deleting both cells and shifting the data up so there are no blanks in the rows.

    For example:
    Column A Column B
    c:\a.doc c:\c.doc
    c:\b.doc c:\a.doc
    c:\c.doc c:\e.doc
    c:\d.doc
    c:\f.doc

    Becomes:
    Column A Column B
    c:\b.doc c:\e.doc
    c:\d.doc
    c:\f.doc

    The easier this is to work with the happier I would be. If it could be done as an executable file that I can point to the Excel file I need to work with, that would be perfect!

    Job Type: Visual Basic


    View Message Board for this Project Messages Posted: 23


    PROJECT BIDS
    Programmers Bid Delivery Within Time of Bid
    Rating
    restyler $20 1 day 10/7/2008 at 12:54 EST
    10.00/10
    (11 reviews)
    See PMB please
    akiles99 $25 0 days 10/7/2008 at 14:27 EST
    9.93/10
    (22 reviews)
    will be done...
    azrajobs $30 1 day 10/7/2008 at 12:46 EST
    9.51/10
    (27 reviews)
    one hour job
    prabhumkk $33 3 days 10/7/2008 at 12:48 EST
    (No Feedback Yet)
    Could you please send the sample file to me to test the application to meet exact output for your requiremets. Please let me know any other information you want from me.
    exceliier1 $35 1 day 10/7/2008 at 12:41 EST
    10.00/10
    (28 reviews)
    I can do it, Please see PMB
    hgong $35 1 day 10/7/2008 at 12:48 EST
    10.00/10
    (1 review)
    vittal $45 1 day 10/7/2008 at 12:41 EST
    9.71/10
    (56 reviews)
    Ready to work...
    jimmychippewa $47 1 day 10/7/2008 at 13:15 EST
    (No Feedback Yet)
    sktsmd $50 0 days 10/7/2008 at 12:37 EST
    10.00/10
    (2 reviews)
    Hello there I am very much interested in doing this. Please check PMB for details. Thanks
    chell $50 1 day 10/7/2008 at 13:11 EST
    (No Feedback Yet)
    I can develop an EXE in a day to do this job. Thanks Chell
    vladnova $75 0 days 10/7/2008 at 12:35 EST
    10.00/10
    (4 reviews)
    Consider it's done Vlad

    Copyright © 2001 - 2008
    ScriptLance is a trade-mark of
    R3N3 International Inc
    Site MapRSSPrivacy PolicyTermsReport ViolationsAffiliatesFAQForumContact Support
    Web Design by: DevFly.com