| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare similar data in two separate workbooks? | Excel Discussion (Misc queries) | |||
| How do I compare similar data in two separate workbooks? | Excel Discussion (Misc queries) | |||
| Two Worksheets similar data | Excel Discussion (Misc queries) | |||
| Compare 2 similar excel worksheets | Excel Worksheet Functions | |||
| How do I compare similar rows of data in same worksheet | Excel Worksheet Functions | |||
Linear Mode
