Forum Discussion
Help - Excel is sortin 10 before 2
Hi My formula is =transpose(sort(unique(reasons))) The reasons name range is just reason 1, reason 2, reason 3 etc. all the way to 10. Except it's not displaying order - Reason 10 is befor...
Hi
I've replicated this exactly and try to fiddle with it - keep getting the there's a problem with this formula error
I've replicated this exactly and try to fiddle with it - keep getting the there's a problem with this formula error
Hi there. i put an excel file for you in my answer. Check it if you have a problem. Probably you tried it before you create a name 🙂
- Didn't work sorry - Data that was then supposed to fall under reason 10 would fall under reason 2, reason 3 data fell under reason 4 etc. Thanks for you help though.
- I am not sure you checked the document which i shared in my answer or not. For this kind of situations you can share the document which you have a problem. That can be easier to get help.