In Progress

Excel Function/Macro

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

I need a MACRO or a TUTORIAL which will be able to sort these for me in the future for multiple spreadsheets.

Skills: Excel

See more: sort function c, c sort function, sort excel, md5, hash , excel function, excel macro sort, sort macro, excel contains, excel macro match data, contains function excel, macro match excel, macro excel 2010, macro values, excel data match, match columns excel, need macro excel, match macro, columns excel, excel related, 30000, excel data columns, emails excel, md5 hash, column data excel

About the Employer:
( 22 reviews ) Victoria, Canada

Project ID: #739225

Awarded to:

mike25

Hi - please see pm for some remarks.

$40 USD in 1 day
(9 Reviews)
3.6

38 freelancers are bidding on average $37 for this job

MAnkita

Hello,Please refer your [url removed, login to view] you.

$100 USD in 0 days
(47 Reviews)
5.7
vserv

Pls see your PMB. Thanks

$30 USD in 1 day
(57 Reviews)
5.7
koolsidz

Please See PMB

$30 USD in 0 days
(94 Reviews)
5.6
best4best

Ready to deliver, please refer PMB.

$30 USD in 1 day
(56 Reviews)
5.0
panfreelancer

Hi, please view my pm, thanks.

$30 USD in 2 days
(22 Reviews)
4.6
SouthIndian

Please check PMB. Thanks.

$30 USD in 0 days
(38 Reviews)
4.4
johnsinit

Dear MitchZ! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$30 USD in 1 day
(11 Reviews)
3.6
bggashnik

Hi! I am ready with your project. Please check your [url removed, login to view]!

$30 USD in 1 day
(8 Reviews)
3.3
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$30 USD in 0 days
(10 Reviews)
3.2
kamosion

It's very simple for me. ~ 30-60 minutes.

$50 USD in 0 days
(2 Reviews)
2.7
Abikris

Hi, Please check your PMB. Kris

$30 USD in 0 days
(5 Reviews)
2.5
hsameer

This task can be achivable by both of the methods; - apply some excel inbuild function OR - by a macro Choose is yours. Please give me a chance to fix your problem ASAP. Check your PM for more detail. Thanks!

$30 USD in 0 days
(2 Reviews)
2.4
ropoint

Hi. Pick me.

$30 USD in 1 day
(2 Reviews)
2.2
pradeep1210

Please see PMB

$30 USD in 0 days
(1 Review)
1.9
indivar

Hi, Kindly see PM and attached files for details. Thanks Inderjeet Singh

$45 USD in 1 day
(1 Review)
1.1
balabeena

I could do this project for you.

$30 USD in 2 days
(2 Reviews)
1.0
JacoB1708

Hi. Will be glad to help you.

$30 USD in 1 day
(1 Review)
1.0
sayli2

I am expert in excel and [url removed, login to view] check PMB for [url removed, login to view]

$30 USD in 1 day
(1 Review)
1.0
Gburg06

I could write a macro for this data that could work with multiple spreadsheets, provided new data is in the same 3 columns.

$35 USD in 2 days
(0 Reviews)
0.0
PriyankaRandive

I have bachelors degree (Major-Electronics & telecommunication)with 3 years of industrial experience

$30 USD in 2 days
(0 Reviews)
0.0