Forum Discussion
Tri automatique et numérotation
- Jun 17, 2024
No idea what version of Excel you run nor on which platform (see recommendations in Welcome to your Excel discussion space!). Searched this site < 5 minutes and found Sorting Column by colors coded. Applied the approach with 365/Windows, works like a charm:
Re. Dans le même temps, j'aimerais que le numéro de bon d'évacuation suive le réagencement
As you can see on the left side of the picture you should select - first - all columns that must follow the sorting or better Format data as Table, in which case all columns will auto. follow when you sort [Transporteur]
No idea what version of Excel you run nor on which platform (see recommendations in Welcome to your Excel discussion space!). Searched this site < 5 minutes and found Sorting Column by colors coded. Applied the approach with 365/Windows, works like a charm:
Re. Dans le même temps, j'aimerais que le numéro de bon d'évacuation suive le réagencement
As you can see on the left side of the picture you should select - first - all columns that must follow the sorting or better Format data as Table, in which case all columns will auto. follow when you sort [Transporteur]
Lorenzo ,
Thank you for your help. It works perfectly, even without the part about "Format data as table". If I see a problem, I'll try to add this point.
Again, thank you.
- LorenzoJun 18, 2024Silver Contributor
Alexandre97441 You're welcome & Thanks for providing feedback
Just to clarify, the point about Table is to make life easier 🙂 In your scenario you would have No column to select first