If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare and count if data elements on two worksheets are similar
I need to compare text in a range of cellw on worksheet 1 to a cell in
worksheet 2 AND text in another range of cells in worksheet 1 to another cell in worksheet 2. If there is a match, place a 1 in the cell on worksheet 2. If there is not a match, place a blank in the cell on worksheet 2. Here is the formula I am using but it does not appear to be reading the information in worksheet 1. Worksheet 1 is 'Mapping Template'. Any ideas? =COUNT(IF(('Mapping Template'!$D$3:$D$1500=Summary!B8)*('Mapping Template'!$E$3:$E$1500=Summary!C8),1,0)) |
#2
|
|||
|
|||
Compare and count if data elements on two worksheets are similar
=SUMPRODUCT(('Mapping Template'!$D$3:$D$1500=Summary!B8)*('Mapping
Template'!$E$3:$E$1500=Summary!C8)) "aascasacspas" wrote: I need to compare text in a range of cellw on worksheet 1 to a cell in worksheet 2 AND text in another range of cells in worksheet 1 to another cell in worksheet 2. If there is a match, place a 1 in the cell on worksheet 2. If there is not a match, place a blank in the cell on worksheet 2. Here is the formula I am using but it does not appear to be reading the information in worksheet 1. Worksheet 1 is 'Mapping Template'. Any ideas? =COUNT(IF(('Mapping Template'!$D$3:$D$1500=Summary!B8)*('Mapping Template'!$E$3:$E$1500=Summary!C8),1,0)) |
Thread Tools | |
Display Modes | |
|
|