|
|
#1
08-03-2014, 07:10 AM
|
|||
|
|||
match two columns of data
I need a formula that will match 2 columns of data. The numbers I want to match are in different columns and in different rows. What formula would find the matches in both arrays and put a 1 next to the ones that match. see example spreadsheet attached.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro for Columns to Row Data
|
brunssl2 | Excel | 3 | 04-24-2014 12:16 PM |
|
From an XL sheet ,how to keep the group of columns which match with other XL sheet
|
Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |
|
Match information from 2 different columns
|
gbaker | Excel | 2 | 08-18-2012 06:07 PM |
| Match two sets of data and display specific data | lolly150 | Excel | 1 | 05-14-2012 10:33 PM |
| If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode