Creating the equivalent of a "hash code" for a workbook
On Dec 18, 3:17 pm, AMADHA wrote:
I have a need to create a single cell value that "sums" an entire workbook
and displays that sum. The goal is to have a quick way to determine if a
printed copy of the workbook matches the electronic version without scanning
each field manually by comparing the contents of just that one cell.
Any ideas?
=SUM(range1,range2,....) etc?
Am I missing something here?
Also, it's not clear that doing this will confirm that an electronic
version matches a digital version. If the value in cell A1 is
decreased by 1 and the value in B1 is increased by 1, the changes will
be a wash, and the sum will appear the same. But it's not the same
document.
Dave
|