Jump to content

NealW

Level 2
  • Posts

    16
  • Joined

  • Last visited

Posts posted by NealW

  1. Since I know Excel, and can work fast in it: I fix sync conflicts by row as follows:

    • Make Excel full screen
    • Copy text from one source starting in A1
    • Copy text from other source starting in B1
    • Make column A and B wide (about 1/2 screen each) but leave Col C visible
    • Select the entire sheet and collapse row height to best fit
    • Scan down the columns and enter a blank cell where needed to keep the column text aligned
    • Enter this formula in C1: =IF(A1<>B1,1,0) and copy it down to the last row with text
    • Where the formula returns 1 there's a sync conflict

    I get only a few sync conflicts per year, so I haven't taken the time to make this into a macro.

    • Like 2
×
×
  • Create New...