I have a simple table with names and two associated percentage numbers - see attached. I asked for the table to be sorted by the second column (Y in this case)…but it does not sort Col y correctly…what am I doing wrong please? This should be really simple…but it does not seem to work for me.
Your ‘percentages’ are actually text strings rather than numeric values, so the sort has worked as designed - but not as you expect.
1 Like
You beat me to it…thank you!
My bad! Numbers were copied across as strings ( I was not expecting that!) which is why the sort did now work properly.