There are many ways of finding matching data in your Excel worksheets, the most versatile of which is filters. Most likely the easiest way is sorting. But if all you really want to do is see the matching values, there is a much quicker way to accomplish this and as you all know, I love to save time and keystrokes!
Follow the steps below to learn how:
- Select/highlight any cell in a column in your worksheet that contains the value you would like to find the matches for.
- Click CTRL + Space to select the column.
- Click CTRL + Shift + \.
The key combination in the last step above selects all the cells in the column that do NOT match the value in the active cell.
Pretty cool eh?