getting a unique number for the contents of a cell

Question

I am looking for a HASH or maybe something even simpler.

I want to return a unique number for every string in a cell.

Does anyone know if there is a function in a cell that will return a unique number or a unique string for another string?

The problem is I would like to compare whether two string are totally equal, I need to be case sensitive.

score -1 · Answer 1 · edited May 23 '17 at 12:30

-1

If you're in C# then can't you just use the standard GetHash function when you have a string variable that contains the contents of the cell?

Otherwise the following stack overflow question seems to already answer this question: Password hash function for Excel VBA

edited May 23 '17 at 12:30

Community

answered Sep 21 '10 at 00:09

Enigmativity

I thought this was a reasonable answer. Could the "down-voter" let me know why I got the down vote? – Enigmativity Sep 28 '10 at 04:23

score -1 · Accepted Answer · answered Sep 21 '10 at 07:35

-1

to compare 2 strings in a case sensitive way ignoring the Option Compare setting use StrComp
IF StrComp(Str1,Str2,vbBinaryCompare)=0 then

answered Sep 21 '10 at 07:35

Charles Williams

2 Answers2