Forum Discussion
Order a column based on another one (copy the order)
Hi! I have 2 columns with the same numbers on them, and I need to order one just like the other. Example: column 1: 13|42|75|3|21 Column 2: 75|3|42|21|13. I need the second one to be in the same order as column 1, like copy the order. How do I do it? Thanks!!
5 Replies
bitbitju Why not copy column 1 to column 2?
Riny_van_Eekelen no because i have more info in more columns that comes with the numbers so there’s no way, I need some king of ‘copy order’ formula or something! Imagine you have a list of customers info and you need to order that info by age but in a specific order, not from youngest to oldest or whatever.. how could that be done?? This question goes to everybody! I hope there’s a way 🤞🏻 Thanks!!
- With sorting you could use a custom list:
https://support.microsoft.com/en-us/office/create-or-delete-a-custom-list-for-sorting-and-filling-data-d1cf624f-2d2b-44fa-814b-ba213ec2fd61
A formula is do-able, too, but would need to see more sample data.
