%% Last Updated: - [[2021-02-10]] %% ## Formulas ### If value in Column B is not found in Column A, print x ``` =IF(ISERROR(VLOOKUP(B2,$A$2:$A$28, 1, FALSE)),B2 & C2,"") ``` ### Find unique value in column A that does not have a specific value in Column B ``` =IF(A1<>A2,IF(B2=1,"","yes"),"") ``` where 1 is the value in B that we're looking for. ### [[Comparing lists of data in Excel]] ## Using [[Visual Basic]] ### How To Start Writing VB Code in Excel In Excel 2010, go to File > Options > Customize Ribbon and make sure the Developer tab is ticked in the right pane. Click OK. You should now see a new Developer tab in the Excel ribbon. Click Visual Basic. You are now in Visual Basic for Applications, where you will do all of the coding for the macros.