Re: hash function for large strings

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

<Still that is the "key" to hashing>

That isn't true. But it is if you want to use it with VLOOKUP.
Maybe you should tell us more about the nature of the lookup problem too.

--
Kind regards,

Niek Otten

"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message
news:ejDMvAhQGHA.3672@xxxxxxxxxxxxxxxxxxxxxxx
It depends on what possible values of each character of the string you can
exclude. If they can be each of the possible 256 characters, there are
limited hashing possibilities; you can treat upper- and lowercase letters
the same, since VLOOKUP will do that anyway. But that doesn't save you a
lot. If there are just the alphabet and 0-9, you can exclude a lot more.
Then you can use a number base conversion function to realize the gain in
storage requirement. It may, however, be difficult to find one that uses
all 256 possibilities. I have seen one (from Ron Rosenfeld) that uses 0-9
and upper- and lowercase letters.

I find it difficult to believe that there isn't any logic behind the
population of your keys. Still that is the "key" to hashing.

Can you tell a bit more about the nature of your keys?

--
Kind regards,

Niek Otten


"jheby" <jheby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB83AD4A-0184-4717-A8E7-8EC893FC86AE@xxxxxxxxxxxxxxxx
Excel vlookup function returns #VALUE when the lookup value exceeds 256
characters. I need a hash function to transform large strings into a
value
that does not exceed the 256 character limit. Are there any quick
solutions
to this problem?




.

Relevant Pages

  • Re: Is this a process that would need VBA?
    ... The very nature of your need of a page break based on if something is true ... would require a macro. ... VLookup in an If statement should get you what you are after. ... If you need to test multiple cells for an X in one if statement, ...
    (microsoft.public.office.developer.vba)
  • Complex VLOOKUP
    ... I have a table lookup problem that I can't seem to solve with the basic ... VLOOKUP. ... array of Date vs Time for the month of December and all ... take a scattered set of data and popoulating it into a contigious set ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Look up and Transfer Data
    ... Functions such as VLOOKUP can easily summarize ... but the formula you'd use depends on the nature and layout of the ...
    (microsoft.public.excel.misc)