To make it a little easier, we have tracked down the best Excel gurus who can help you master Microsoft Excel. Read More that can find duplicates in the column next to our first set of data. We’re going to use COUNTIF, which uses the syntax COUNTIF(range, criteria).
![How many columns in excel How many columns in excel](/uploads/1/2/5/4/125482525/317459925.png)
I'm making a couple of assumptions here to allow me to answer the question. You may need to adjust the cells accordingly:. Your column A data is in cells A1:A11592. Your column B data is in cells B1:B12555 We need to setup column C to show the values in B which are not in A. We'll do this with a formula in each cell of C1:C12555 (one cell for each value in col. B we will test). As a second step we can sort column C to put the found values at the top of the list.
Create a formula in cell C1: =IF(ISNA(VLOOKUP(B1,$A1:$A11592,1,FALSE)),B1,'). Copy C1 to all cells C1:C12555 (see tip at end) Now each cell in column C contains the value next to it from Column B if that value doesn't occur in Column A, or a blank (an empty string) if it does occur. To get all of the values in col C together, you can select columns B and C together, and sort on column C.
TIP: to quickly copy C1 to over 12000 rows, try this:. select cell C1, press Ctrl-C (Command-C on Mac) to copy. Using the arrow keys, move left to cell B1. Press the 'end' key, and the the 'down arrow' key. This will jump you to the last non-blank value in column B (i.e., the 'end' of the column). This assumes that you don't have any blank values in the middle of column B's data.
Using the arrow keys, move right to column C (should be cell C12555). Holding the SHIFT key, press 'end' and 'up arrow' to jump back to the top of column C; since you held SHIFT the cells are all selected. Press Ctrl-C to paste the copied function to all cells.