Alex O
Active Member
- Joined
- Mar 16, 2009
- Messages
- 345
- Office Version
- 365
- Platform
- Windows
I can't believe I have to ask this, but why is COUNTIF treating these two obviously different strings as if they match? I'm attempting to create a unique key for each transaction, which I thought was easy enough. Clearly there's something I'm missing here?? Any insight would be appreciated....
DP REPORT - MASTER RECORD
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 140px;"><col style="width: 140px;"><col style="width: 281px;"><col style="width: 112px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]332[/TD]
[TD="bgcolor: #D9E1F2"]$400.00 [/TD]
[TD="bgcolor: #D9E1F2"]11/27/2018[/TD]
[TD="bgcolor: #D9E1F2"]4341610001914190400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]333[/TD]
[TD="bgcolor: #D9E1F2"]$550.00 [/TD]
[TD="bgcolor: #D9E1F2"]11/27/2018[/TD]
[TD="bgcolor: #D9E1F2"]4341610001914190550[/TD]
</tbody>
<tbody>
</tbody>
DP REPORT - MASTER RECORD
G | H | I | J | |
1 | ||||
1 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 140px;"><col style="width: 140px;"><col style="width: 281px;"><col style="width: 112px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]332[/TD]
[TD="bgcolor: #D9E1F2"]$400.00 [/TD]
[TD="bgcolor: #D9E1F2"]11/27/2018[/TD]
[TD="bgcolor: #D9E1F2"]4341610001914190400[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]333[/TD]
[TD="bgcolor: #D9E1F2"]$550.00 [/TD]
[TD="bgcolor: #D9E1F2"]11/27/2018[/TD]
[TD="bgcolor: #D9E1F2"]4341610001914190550[/TD]
</tbody>
Formeln der Tabelle | ||||||||||
<tbody> </tbody> |
<tbody>
</tbody>