+ Reply to Thread
Results 1 to 2 of 2

Thread: Matching codes and data into one row

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    Matching codes and data into one row

    Dear Sir,

    I have a query about using excel to match data in the same row. I have a set of 6000 datas called the master list. this data is made out of 2 sorted columns namely "Code" and "Quantity". every month i will receive a new set of data with random codes and quantity which is not sorted out properly. My question is "How do i match these codes and quantity in the same row for 6000 data without manually inserting the quatity into the master list?" Managing this kinda work without a proper software is tedious and i would very much appreciate if dear sir could help me out in this miserable situation of mine. And if excel can not work for this kind of task, can dear sir suggest another software that can? Hope to hear from Sir as soon as possible.

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007
    Posts
    615

    Re: Matching codes and data into one row

    Upload a sample workbook with sample data and your desired results

    In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

+ Reply to Thread

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.2.0