Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing one cell to every cell in another column
I have a workbook that imports data from two separate text files. I wan to find any matches between the two sets of data, but they will not b in the same order. IF Cell in Column 1 (from data import 1) = Any Cell in Column 2 (from dat import 2) THEN Column 3 = "MATCH" I'd like to do this for every cell in column 1. The lists can up t 1000 rows long. If anyone out there can help me, I'd greatly appreciate it! THANKS! Ale -- ExcelAle ----------------------------------------------------------------------- ExcelAlex's Profile: http://www.excelforum.com/member.php...fo&userid=1555 View this thread: http://www.excelforum.com/showthread.php?threadid=27116 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing one cell to every cell in another column
In C1:
=if(isnumber(match(a1,b:b,0)),"Match","NoMatch") and drag down. ExcelAlex wrote: I have a workbook that imports data from two separate text files. I want to find any matches between the two sets of data, but they will not be in the same order. IF Cell in Column 1 (from data import 1) = Any Cell in Column 2 (from data import 2) THEN Column 3 = "MATCH" I'd like to do this for every cell in column 1. The lists can up to 1000 rows long. If anyone out there can help me, I'd greatly appreciate it! THANKS! Alex -- ExcelAlex ------------------------------------------------------------------------ ExcelAlex's Profile: http://www.excelforum.com/member.php...o&userid=15554 View this thread: http://www.excelforum.com/showthread...hreadid=271165 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
IF Statement for On One Cell Comparing to the Other Cell | Excel Worksheet Functions | |||
Comparing cell contents, know cell address | Excel Discussion (Misc queries) | |||
comparing a column of cell and then copy info to other cells | Excel Discussion (Misc queries) | |||
comparing cell | New Users to Excel |