Checksum on a group of cells

  • Thread starter Thread starter Tobias Gårdner
  • Start date Start date
T

Tobias Gårdner

Hi,

I would like to create a checksum on a group of cells (e.g. A1:D10). The
cells can contain both numbers and text. The A column contains a reference
towards another sheet and B:D contains VLOOKUP results based on A.

One alternative is to use SUM(A1:D10) but that checksum will not indicate if
a cell with text has been changed, i.e. it will only take me part of the way
towards my goal. In addition, if one cell has increased by one and another
has decreased by one, the checksum will be of no value at all (only
misleading).

Please,
Does anyone have an idea on how this can be solved. If not, does anyone know
if this is possible at all in excel? If not, I can stop looking for a
solution now...

Best regards,
Tobias Gårdner
 
What I would do is copy and paste special > value the
original values to another range, say H1:K10. Then use
conditional formatting on the A1:D10 to highlight any
cells that may have changed.

1. Select A1:D10.
2. Go to Format > Conditional Formatting
3. Select "Formula Is" and insert:
=A1<>H1
4. Press the "Format" button and format as desired. OK out.

HTH
Jason
Atlanta, GA
 
Back
Top