Exceljet

Quick, clean, and to the point

Select row differences

Windows shortcut 
Ctrl\
Mac shortcut 
\

This shortcut will select all cells that don't match the value in the active cell in a row or selection within a row. Note that this shortcut depends on the location of the active cell in a selection. You may want to start your selection with the active cell or move the active cell after the selection is made.

Love your tutorials, they've been awesome in helping me learn all that Excel can do.
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course