Countif without converting TEXT to NUMBER
<p>I'm trying to set a macro, that will compare multiple lists, create a cross-table with unique values and display how many times the value is present in each list. </p>

<p>I'm doing OK, with one exception. When using <code>Countif(s)</code> formula <code>=COUNTIFS(Source!$A$2:$A$5;[@Values])</code>, it internaly converts "Text numbers" (e.g. 001, 00000002) into Numbers (e.g. 1, 2). I would like to avoid this behaviour and search for EXACTLY the same value, without converting.  </p>

<p>Example data:</p>

<pre><code>List1      List2
1          0001
0001
2
00000002
</code></pre>

<p><strong>What I'm getting right now (WRONG):</strong> </p>

<p><a href="https://i.stack.imgur.com/nECXX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nECXX.jpg" alt="CompareListsWrong"></a></p>

<p><strong>What I want to get (EXPECTED):</strong><br>
<a href="https://i.stack.imgur.com/3SDE9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3SDE9.jpg" alt="CompareListsExpected"></a></p>

<p><strong>My question:</strong><br>
How can I count EXACTLY the values in the list, without internaly converting "Text numbers" to Numbers?</p>