I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master version, but they do not always indicate where they have changed cell values from the previous version. Is there a function that will create say a 4 digit hash value across all cells in a row (both numeric and text) ?
If so I could use that to compare the new spreadsheet Row hash value to previous spreadsheet version hash value for same row and then highlight rows that have incorporated any change over the previous version.
I can't use VBA or macros as these are frowned upon in my organisation. Your help appreciated.
p.s. The hash value can be anything as long as it uses all contents of all cells in a row to derive itself.