Hi guys, I am currently preparing for an Excel test. I downloaded a list of transactions from CAPIQ but can not seem to be able to sort the value columns by number (ex: from least to greatest). It only lets me sort from A to Z. I have tried copying and pasting into a brand new column but it still won't work. Can someone help me on this?
| Attachment | Size |
|---|---|
| retail_transactions.xls 493 KB | 493 KB |
| +161 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 18h |
| +133 | Is pay at BofA really that bad? | 64 | 4h |
| +90 | Day at Macquarie | 12 | 1d |
| +80 | Worlds Worst MDs Competition (2026 Edition) | 17 | 3h |
| +46 | How bad did I mess up | 10 | 1d |
| +45 | Is the life of a VP at a 'top-bank' really good? | 15 | 4d |
| +31 | Misrepresented Houston IB | 14 | 1d |
| +30 | Lindsay Clancy - Thoughts from A2 | 6 | 44m |
| +29 | No BB RO 2026 | 10 | 3d |
| +29 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 1d |
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.
Select the entire table, go to DATA tab, then click Sort. You can then sort columns by whatever you want, also check the "my table has heads" box if it does.
I understand how to use the sort function. The problem is that the option for a numerical value does not show up. Only A-Z.
Uhh sort from high to low or vice versa?
Yeah the problem is that option isn't showing up. It is only showing A-Z when i click the drop down menu.
See my comment. A-Z includes proper sorting of numbers.
A to Z will sort numbers correctly unless you have extra spaces in front of the numbers.
Try formatting the values column to numbers and then sort. To be certain, just check that there aren't any unusual characters impeding excel's ability to identify each value as a number. CIQ data should be fine though.
Sorting worked for me on the file you uploaded.
It works for lowest to highest but I try Z to A trying to go from highest to lowest, the dashes (0's) come up first. Is there any way around this?
Are the dashes the problem? It's not Excel as I just made a random list of numbers and it's sortable from highest to lowest.
Consequatur numquam quis quod deserunt. Distinctio optio facilis iste odio id sint.
Et nihil dolorem et quisquam atque nostrum unde et. Aliquid officia voluptas vel aspernatur quae recusandae inventore laborum. Magni possimus aperiam dolorem quasi qui quam qui. Ut eos velit voluptas vitae quia necessitatibus ex. Qui minus quo fuga omnis voluptatem et. Dolores autem eveniet non consequatur aut eveniet. Sint rerum non provident eos at dignissimos.
Fugiat similique pariatur corporis. Quis autem ut ipsum est in harum dolorem. Quasi quos perspiciatis odio enim voluptatum et quia.
Sequi iste hic architecto natus ducimus ea commodi. Eos totam eveniet repellendus minus. Non est est voluptas minus aspernatur voluptatum et repudiandae. Nobis dicta quia exercitationem recusandae aut. Fugiat consequuntur et ipsa debitis quos. Beatae molestiae totam ipsa autem asperiores perferendis. Ut molestias dolorem impedit officia sapiente.
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...