Forum Discussion
>">" Logic Question
I love looking at the Excel BI Challenges on Linked in. I was going back over challenge 7 and saw a new answer with some new logic that I don't quite understand. Here is the challange Provide a fo...
When comparing text values with greater than or less than operators, the result is based on the sort order. To illustrate, place the following formula in cell A1:
=SORT(CHAR(SEQUENCE(93,,33)))Then, in cell B1:
=A1#>">"You'll notice ">" is the last symbol in the array that comes before any of the numbers and letters, which is why everything that comes after returns TRUE.
Thanks. It was weird after I did sort it; but it now makes sense. Thanks again.
