How do I get a checksum of a range of cells?

W

woodsmoke

Excel 2003 SP3

I want to check data before and after it has been migrated between 2 systems
- and prove it has survived intact - using a checksum or similar.

Each dataset could be a range of numeric fields, eg telephone numbers, or
text data eg postcodes. Ideally each column would have a checksum at the
bottom which could be compared across 2 (or more) spreadsheets.

Any help greatly appreciated.
 
H

Héctor Miguel

hi, ?

- when the exact time shall it be for both moments ? (put & verify a checksum)
- which column/s you need to be as checksum ? (and what type it's data ?)
- the number of rows could increase/decrease between migrations ?
- *IF* any changes... what would you like to do ?

(remember... we can only "see what you tell" in your post)

regards,
hector.

__ OP __
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate a checksum (e.g. md5) on a group of cells 0
How can I print rows that go outside of the page without shrinking the text? 0
*Issue* Concatenate dates in a large range of cells in a row. 5
I must make certain I have a specific range of numbers present. 3
Counting multiple occcurrences between date range 3
How do I have a cell value define a dynamic named range? 15
Automatically chnage number format of a range of cells 2
How to Color a Cell Based on a Range of Cells with Colors 1

Top