Everything posted by NealW
To resolve the annoying Conflicting Modifications, I use Excel to find text changes Paste each version in a separate column at Row 1 Scan the rows and insert cells to keep the same text on the same row In Row 1, insert this formula =IF(A1<>B1,1,"") in the first unused column Copy the formula right as many versions as you had less one Copy the formulas down to the last used row Wherever a 1 shows up, there's the conflict.While a bit tedious, this does find all the text conflicts. Changed formatting won't be found. It also will find edits as well as new lines.
Since I know Excel, and can work fast in it: I fix sync conflicts by row as follows: Make Excel full screenCopy text from one source starting in A1Copy text from other source starting in B1Make column A and B wide (about 1/2 screen each) but leave Col C visibleSelect the entire sheet and collapse row height to best fitScan down the columns and enter a blank cell where needed to keep the column text alignedEnter this formula in C1: =IF(A1<>B1,1,0) and copy it down to the last row with textWhere the formula returns 1 there's a sync conflictI get only a few sync conflicts per year, so I hav