350Z Pilot
Board Regular
- Joined
- Nov 18, 2008
- Messages
- 64
Recently one of my vendors switched to a 19 digit Order Ref# and it's driving me nuts. Below is a simplified example where I'm counting the number of times the Ref# in cell A14 appears in range A1:A14. My formula, =COUNTIF(A1:A14,"="&A14), counts "4 times" but the correct answer is "1 time". NOTE: The Ref #s are formatted as TXT. Are the Ref #s just to big for Excel 2010 to handle? Any help would be appreciated.
Thanks in advance
<tbody>
</tbody>
Thanks in advance
1 | Order Ref No |
2 | 1408149900002224029 |
3 | 1409039900002387409 |
4 | 1409089900002488939 |
5 | 1409059900002518343 |
6 | 1409089900002490397 |
7 | 1409039900002387599 |
8 | 1409049900002533179 |
9 | 1409059900002521827 |
10 | 1409089900002489247 |
11 | 1409089900002489554 |
12 | 1409089900002491259 |
13 | 1409089900002491446 |
14 | 1409089900002490802 |
15 | |
16 | 4 |
<tbody>
</tbody>