I have created the following formula to produce a hex checksum for a cell of text.
{=DEC2HEX(SUM(CODE(MID(A9,ROW(A1:OFFSET(A1,LEN(A9)-1,0)),1))),5)}
I want to use the checksum to make sure the text hasn't been changed. The problem is I can't copy this formula because it's a dynamic array. I have included a spreadsheet of some sample data and how I'm using the formula. Does anyone have solution that will give the same result and allow me to copy it?
Bookmarks