|
|
#2
08-03-2014, 04:01 PM
|
|||
|
|||
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode