Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi guys, I have a big worksheet with a ton of columns, what I need to do is
find all the numbers from column B that are in column A and create a list of cells from column B that are unique and not in column A. The sheet looks like this but goes on for 5K rows. If you look at the 2 columns the first number in column B (11971268365) is also in column A and I don't want that number. I do want the 2nd and 3rd number (etc). Can you guys help me do this? I can't seem to figure it out on my own. Please feel free to e-mail me as well Thanks guys A B CU83201 AcctNum 6100038 11971268365 2545179031 13519408214 11971268365 14120788327 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding duplicates | Excel Discussion (Misc queries) | |||
Finding duplicates in Excel 2003 | Excel Worksheet Functions | |||
Finding duplicates in Excel | Excel Discussion (Misc queries) | |||
Finding duplicates | Excel Worksheet Functions | |||
Finding Duplicates | Excel Worksheet Functions |