• Compare 2 columns in excel

  Articles on: Excel Compare 2 columns in excel Conditional formatting Select both column                 Conditional formatting, highlight duplicate with color                 Conditional formatting, highlight unique with different color =Vlookup(A2, select range and lock,1,0) =iferror(vlooFew readers

• **Searchable Drop Down List on Separate Sheets**

  Articles on: Excel Searchable Drop Down List on Separate Sheets Min 4 x column are required on source sheet Cell A2                  A1 is empty cell and A2 formula is (Past and Drag to end) =IF(ISNUMBER(SEARCH(INDIRECT(CELL("Address")),B2)),MAX($A$1:A1)+1,0) Original List        Original List is only your teFew readers