Excel 2013 64-Bit: I have a list of text that will NOT count correctly (to get the alphabetical order) and, for the first time I know of, I am unable to find any previous discussion anywhere that is relevant.
<tbody>
</tbody>
Column A and the values within are formatted as TEXT.. When that alone didn't work, I added ' to the beginning of the text in A2 and A5. The ORDER will NOT calculate correctly no matter what I try because it insists on treating A2 and A5 as values. Any suggestions other than adding space or concatenating it with another text value (which I already confirmed does work but SHOULDN'T BE NECESSARY)?
Thanks!
A | B | C | D | |
1 | ITEM | ORDER | FORMULATEXT | CORRECT ORDER |
2 | 1062287 | 0 | =COUNTIF($A$2:$A$6,"<="&$A2) | 1 |
3 | 1062740 Folio | 2 | =COUNTIF($A$2:$A$6,"<="&$A3) | 2 |
4 | 1063209 Part | 3 | =COUNTIF($A$2:$A$6,"<="&$A4) | 3 |
5 | 1063648 | 0 | =COUNTIF($A$2:$A$6,"<="&$A5) | 4 |
6 | 1063832 Folio | 5 | =COUNTIF($A$2:$A$6,"<="&$A6) | 5 |
<tbody>
</tbody>
Column A and the values within are formatted as TEXT.. When that alone didn't work, I added ' to the beginning of the text in A2 and A5. The ORDER will NOT calculate correctly no matter what I try because it insists on treating A2 and A5 as values. Any suggestions other than adding space or concatenating it with another text value (which I already confirmed does work but SHOULDN'T BE NECESSARY)?
Thanks!