Closed

Excel Function/Macro

This project was awarded to mike25 for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
38
Project Description

I need to sort 3 columns of data.
First column is Emails (A), second is MD5 hash (B) and third is MD5 hash (C).
Column A - Emails contains 6 values in example. (Realistically 30000)
Column B - MD5 Hash contains 6 values in example. (Realistically 30000, ALWAYS The same as Column A)
Column C - MD5 Hash contains 3 values in example. (Realistically 500)

Step 1:
I need to Match the MD5 from Column C to the MD5 in Column B.
Example: (From SCRAMBLED - ORIGINAL DATA)
ColumnA ColumnB ColumnC

email1 u1728u7 kj9898d
email2 kj9898d lkj3k4j
email3 lkj3k4j kl2j13j
email4 j23jk1l
email5 kl2j13j
email6 2lk3j1l

Finished example: (To sorted)
email1 u1728u7
email2 kj9898d kj9898d
email3 lkj3k4j lkj3k4j
email4 j23jk1l
email5 kl2j13j kl2j13j
email6 2lk3j1l

Step 2:
I need all the values in Column C moved to the top with their related Column A and Column B
:

Example:
email5 kl2j13j kl2j13j
email2 kj9898d kj9898d
email3 lkj3k4j lkj3k4j
email1 u1728u7
email4 j23jk1l
email6 2lk3j1l

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online