Closed

Excel Function/Macro

This project was awarded to mike25 for $40 USD.

Get free quotes for a project like this
Employer working
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