Hope someone can help me out with this. Let's say that I have data that goes left to right... C1, C2, C3, C4...C998, C999, etc.
How do I quickly reverse the data and make it go C999, C998...C4, C3, etc? In this example, the data is not alphabetical so I can't just use data->sort.
| +391 | Change My Mind: Banks Shouldn’t Hire Foreigners at All | 109 | 22m |
| +170 | Article - UBS’ Investment Bank Keeps Losing Ground | 34 | 2h |
| +78 | An Exhaustive Guide: How to Solve Every Single Accretion/Dilution Question | 6 | 5h |
| +51 | When to Leave Office as Intern | 5 | 2d |
| +43 | Best IB Group Overall? | 25 | 23h |
| +38 | Don’t work at UBS - UBS Sucks | 5 | 1h |
| +34 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 2d |
| +31 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 22 | 1d |
| +31 | STEM student lost in London IB recruiting | 17 | 12h |
| +20 | Still recruiting SA'27 | 13 | 10h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Insert a column. Number the rows 1 through 999 with autofoll. In the next column over link to d999-current row. Then copy paste these values into the original location.
There's probably an easier way...
Might be an easier way but that's pretty easy. Seems so obvious now (I'm an idiot)... thank you for the help.
perhaps not the best way to do it but copy the data and then do a paste special (transpose so u can past the data vertically. then add numbers in on the column next to it and drag the numbers as far as you need them. then sort the numbers from high to low but make sure to expand the selection so it reverses the data you want
Error repellendus minima ad voluptatem alias. Incidunt dignissimos aut molestias veniam placeat rerum molestias. Non consectetur occaecati ratione maiores.
Qui aut dolorum quam qui. Harum perferendis molestiae soluta hic et dicta non corrupti. Nostrum earum necessitatibus deserunt quia eum eligendi. Fuga ut velit aspernatur fuga doloremque et laboriosam.
Optio dolorem tempore pariatur et est exercitationem ex. Magnam quia sint suscipit neque sint. Ducimus et quia reiciendis earum. Dolor omnis facere deserunt corporis. Et quas ullam quidem adipisci et aut esse. Soluta autem fugiat id commodi earum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...