database style composite key compare
Performs a cell-by-cell comparison of Excel Worksheets.
Brought to you by:
stevetowner
Menu
▾
▴
#14 database style composite key compare
In a spreadsheet, I have no primary key. I need to make a composite compare key of three text columns. If I select Database Style Compare and select by range, it would be good to be able to select a range of cells that make up the composite key to compare between spreadsheets. For example, I could select the first 3 columns.
As Steve suggested, a work around is:
"What you will need to try is to add a new column and concatenate the three columns you want into one (=Concatenate(...)) to provide a unique single column key."
thanks
