LinkBack URL
About LinkBacks
Hi all,
I was wondering if there's a way to perform hashes in excel 2011 (MAC), specifically MD4, MD5, and sha256?
All the threads I found on the subject were from 2011, locked, or had outdated links and information.
Thanks in advance for your help!
Hashing in Excel
Hi all,
I was wondering if there's a way to perform hashes in excel 2011 (MAC), specifically MD4, MD5, and sha256?
All the threads I found on the subject were from 2011, locked, or had outdated links and information.
Thanks in advance for your help!
I put "hashing in Excel" into my favroite internet search engine and found many workable links and discussions. This one might be of particular interest: http://web.archive.org/web/200805260...eecode.htm#md5
Originally Posted by shg
Thanks a ton. I'll go through this
Update:
I downloaded files from the link you gave, and there's code present in the HTML files which I believe is VB. I tried copy-pasting the code (No VB experience, I'm afraid) and couldn't get it to work. I tried defining it as a macro as well but to no avail.
The particular files in question were the 'sha256 digest' and 'MD5 digest' zips.
It is too bad that you have no VB experience, because it seems that the Frez link I posted is intended for those with significant VB experience. Since I do not have any experience with class modules (or otherwise trying to import stand-alone VB code into VBA for applications), I'm not sure how to import this code into Excel, either. Perhaps someone will come along who is more experienced with VB and help you import this into your VBA installation.
Have you tried other internet searches? I have to believe that you are not the first person ever to want to hash data in Excel, and that someone somewhere has done it before.
I tried "md5 algorithm in Excel" in my favorite internet search engine and, among others, found this http://softwaretopic.informer.com/md5-algorithm-in-vba/ perhaps one of these will be easier for someone with no VB experience to use.
(At the same time, I'm starting to feel like a professional internet searcher. It seems like it would save us both time if you were putting these search terms into your own favorite internet search engine and wading through the many hits yourself.)
Do you particularly need one of those hashing schemes, or would CRC32 do?
Entia non sunt multiplicanda sine necessitate
It's the aforementioned hashes in particular that I need, sorry.
From the link:
Outputs:
Please Login or Register to view this content.
Which is correct, to use, simply download the sha256 & md5 zips, extract the cls files and copy and paste each into a new class module (you could import them too). Copy down from the beginning of the starred comment line (you don't need the stuff before). I've called the classes MD5 and SHA256 in the above, but you may name them whatever you like.Please Login or Register to view this content.
Or since this works quite neatly with an interface, I'd be tempted to (knock one up and) simply use:
Please Login or Register to view this content.
Last edited by Kyle123; 11-17-2015 at 12:09 PM.
Thanks, Kyle. I have imported the files as such:
Screen Shot 2015-11-18 at 13.49.03.png
How would I go about having one column of strings populate a separate column with a hash of those values?
Thanks again
Please upload a sample workbook
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Morning, here's a sample workbook.
HashingExample.xls
I'm trying to set up things so that the input column automatically generates the MD4, MD5, and Sha256 hashes into 3 other columns. I have imported the class files across but I'm unsure what to do with them. As of this point I've yet to locate a MD4 .cls file. Once I understand how the other two are used I should be fine and can set out looking for one.
Thanks in advance.
You haven't imported them properly, delete everything above the green comment text. So the top of each class looks like this (obviously different for the SHA version):
Then in a standard module:Please Login or Register to view this content.
Then in D4:Please Login or Register to view this content.
I4:Please Login or Register to view this content.
Please Login or Register to view this content.
Okay, I've done that, I think. I removed the text above the screen content and both class files start as you specified.
The functions show up in predictive text for cells, but the algorithm simply returns #REF! though.
HashingExample.xls
It must be something with your computer, your workbook works fine for me. Your formulas looked weird, they showed as:
But once I'd changed them to the correct names, everything works as expectedPlease Login or Register to view this content.
I'm inputting the correct names but they return #REF!. If I exit and reopen the workbook the inputs change to #REF! as well. I've tried saving it as .xlsm but there's been no change to this issue
Does it work on a windows version?
Is it possibly the same issue as this one: http://www.excelforum.com/excel-form...ml#post4170502 Since SHA256 is a valid cell reference in 2007+, having named your UDF SHA256, you are creating a naming conflict that Excel does not handle correctly. Try renaming your UDF's to something that does not look like a cell reference.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks