LinkBack URL
About LinkBacks
I have a table containing both text and numbers and I want to create a checksum value for whole table.
Does Excel have any relevent functions?
I have a table containing both text and numbers and I want to create a checksum value for whole table.
Does Excel have any relevent functions?
Not sure what you mean by checksum value, but the Sum() function will sum only the numbers within a table of mixed numbers and text strings (in separate cells).
e.g. =Sum(A1:D10) will sum all numeric cells within the range.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Mayb checksum is the wrong word. Each cell in my table contains either a string or a number. I am looking for a value for the whole table which I can compare with the value for a new table so that I can indentify if any character has changed (but I don't need to know which character has changed).Originally Posted by NBVC
Please supply an example of your data with expected results.
Typical table as follows:
Aveva -0.0902
Babcock -0.0448
Balfour -0.0907
Bankers -0.0435
BBA -0.0902
Beazley -0.0118
Bellway -0.2685
Benfield -0.0484
Berkeley -0.3203
Biffa 0.0198
Big -0.2135
BlueBay -0.1360
Bodycote -0.2231
a new table for comparison is as follows:
Aveva -0.0902
Babcock -0.0448
Balfour -0.0907
Bankers -0.0435
Barclay -0.0902
Beazley -0.0118
Bellway -0.2685
Benfield -0.0484
Berkeley -0.3203
Biffa 0.0198
Big -0.2135
BlueBay -0.1360
Bodycote -0.2231
I need a function to tell me that the tables are the same (True) or different (False)
Here's one way...
If your first table covers A1:B13 and the second table covers E1:F13, then try:
If there are any differences between the tables, you should get FALSE result.
Please Login or Register to view this content.
EDIT:
Slight amendment to take into account blank cells in the tables:
Please Login or Register to view this content.
Last edited by NBVC; 01-16-2008 at 09:56 AM.
Slight amendment to take into account blank cells in the tables:
Please Login or Register to view this content.
Brilliant!
Simple and elegant - I like it and it works!
Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks