Forum Discussion
Sorting column with Concat formula does not produce Low to High
Using CONCAT on numbers converts the results to text. I just did it to test. You're not showing us here where or how you used VALUE, as you said you did in your opening post.
So the sort of your column D is going to sort as text unless you've done something else in an intermediate stage.
An easier way to get the value in A or the value in B, which really appears to be your goal, since one or the other of the two columns is going to be blank, given the "Debit"/"Credit" headings, would be the formula
=IF(A3="",B3,A3) or =MAX(A3,B3); the latter works since both numbers are positive and one of them, by definition, is zero.
CONCAT should be reserved for its intended purpose, which is concatenating--putting together--two text strings.
It sounds like A and B have numbers but it's not certain which column might have the number in a given row.
If that's the case, you could use something like this:
=SORT(TOCOL(A1:B20,1))
Thanks Patrick2788 .
the spreadsheet looks like this:
Sorting the Concate column (D) does not sort in either ascending or descending order, but rather sorts in, what I think is called, a decimal sort.
Thank you for your help.
LansFP.
Using CONCAT on numbers converts the results to text. I just did it to test. You're not showing us here where or how you used VALUE, as you said you did in your opening post.
So the sort of your column D is going to sort as text unless you've done something else in an intermediate stage.
An easier way to get the value in A or the value in B, which really appears to be your goal, since one or the other of the two columns is going to be blank, given the "Debit"/"Credit" headings, would be the formula
=IF(A3="",B3,A3) or =MAX(A3,B3); the latter works since both numbers are positive and one of them, by definition, is zero.
CONCAT should be reserved for its intended purpose, which is concatenating--putting together--two text strings.
- Excellent. I'll remember concat converts.
You are very good at reading minds.
Thanks!!
