#1
|
|||
|
|||
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.
|
#2
|
|||
|
|||
Hi
Use COUNTIF() and just count the value of a cell within a column: B3 =COUNTIF($D$3:$D$31,A3) E3 =COUNTIF($A$3:$A$31,D3) Copy the formulas to the end of your list. It will return 0, if there's no match. You are using a text-format for numbers! I wonder why. Be aware that the above formulas if looking for a text won't find a match in case the same value exists as number (and viceversa). It will return 0. |
|
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 |