Another (sometimes quicker) way to compare against column B is to select columns A:C (starting in column A), then press Tab, which keeps the selection, but moves the active cell to the next cell in the selection, in column B.
By the way, the Tab key can also help if you select a range from the top-left, but want to get to the last cell in the range - just press Shift-Tab to move backwards one cell.
Also, thank you Susan, for providing a demo spreadsheet to experiment with!
Discussion on:
Message 17 of 25

































