| 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 |
| 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 | |||
Threaded Mode
