Devam Ediyor

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.

Beceriler: Excel

Daha fazlasını görün: 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

İşveren Hakkında:
( 22 değerlendirme ) Victoria, Canada

Proje NO: #739225

Seçilen:

mike25

Hi - please see pm for some remarks.

1 gün içinde 40$ USD
(9 Değerlendirme)
3.6

38 freelancer bu iş için ortalamada 37$ teklif veriyor

MAnkita

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

in 0 gün içinde100$ USD
(47 Değerlendirme)
5.7
vserv

Pls see your PMB. Thanks

1 gün içinde 30$ USD
(57 Değerlendirme)
5.7
koolsidz

Please See PMB

in 0 gün içinde30$ USD
(94 Değerlendirme)
5.6
best4best

Ready to deliver, please refer PMB.

1 gün içinde 30$ USD
(56 Değerlendirme)
5.0
panfreelancer

Hi, please view my pm, thanks.

in 2 gün içinde30$ USD
(22 Değerlendirme)
4.6
SouthIndian

Please check PMB. Thanks.

in 0 gün içinde30$ USD
(38 Değerlendirme)
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.

1 gün içinde 30$ USD
(11 Değerlendirme)
3.6
bggashnik

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

1 gün içinde 30$ USD
(8 Değerlendirme)
3.3
oFAZo

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

in 0 gün içinde30$ USD
(10 Değerlendirme)
3.2
kamosion

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

in 0 gün içinde50$ USD
(2 Değerlendirme)
2.7
Abikris

Hi, Please check your PMB. Kris

in 0 gün içinde30$ USD
(5 Değerlendirme)
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!

in 0 gün içinde30$ USD
(2 Değerlendirme)
2.4
ropoint

Hi. Pick me.

1 gün içinde 30$ USD
(2 Değerlendirme)
2.2
pradeep1210

Please see PMB

in 0 gün içinde30$ USD
(1 Değerlendirme)
1.9
indivar

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

1 gün içinde 45$ USD
(1 Değerlendirme)
1.1
balabeena

I could do this project for you.

in 2 gün içinde30$ USD
(2 Değerlendirme)
1.0
JacoB1708

Hi. Will be glad to help you.

1 gün içinde 30$ USD
(1 Değerlendirme)
1.0
sayli2

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

1 gün içinde 30$ USD
(1 Değerlendirme)
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.

in 2 gün içinde35$ USD
(0 Değerlendirme)
0.0
PriyankaRandive

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

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0