Trending Content - Investment Banking Forum
| +405 | Evercore Intern Seizure | 62 | 6h |
| +112 | UBS IB Americas has failed, now behind Santander and Stiffel | 31 | 11m |
| +79 | JPM M&A is Gone??? Purely Coverage Banking??? | 42 | 4h |
| +60 | How do I understand vs. just memorizing? | 11 | 9h |
| +48 | Losing my personality in Banking | 9 | 2d |
| +45 | The good and bad with Wells Fargo | 14 | 1h |
| +42 | Associate & Above IB exits | 18 | 11h |
| +39 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 23 | 49m |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 8h |
| +33 | Some banks are overrated as fuck | 10 | 4h |
Career Resources
alt i r inserts a new row
hit the down arrow twice then hit F4, rinse and repeat until done.
say there are 1000 rows, i want to insert a blank row after each of the 1000 rows. alt i r doesn't insert after every row.
insert a row then move down 2 cells (relative reference). Then create the loop to repeat it 1000 times.
no need for macros for such an easy task
insert a new column put in numbers multiples of 2 with mod 2 value = 0 (0,2,4,6 etc.) in that new column in each row (many ways to do it, from dragging the corner of the cells to use a formula and then copy value)
put in numbers multiple of 2 with mod 2 value = 1 (1,3,5,7) in the empty rows below your last row with data, in similar manner
use a stupid sort on that column
delete the extra column
tada...
Now that is some creativity!
yup, i did 0.5 increment. thank you for your help!
would have never occurred to me. i like the outside-the-box thinking!
this sounds like an interview question...hmmmm
is that sometimes you get hit with unintended consequences.
I agree that the solution proposed by jajaja is an elegant one but only works if the rest of the dataset is hard-coded or absolute referenced for cells. If it isn't then the links will be messed up.
Occaecati perspiciatis similique cum mollitia est iusto eaque. Consequatur ex libero qui quia pariatur. Perferendis non iste ex illum aut. Esse aut ut sit assumenda voluptatum animi esse.
Est minus qui quas modi perferendis rerum aperiam. Aperiam voluptatem unde qui fugiat ex. Deserunt at dolor dicta excepturi porro qui non fugit. Dignissimos itaque id praesentium occaecati ut eum soluta. Itaque voluptatem debitis sit consequatur ut id.
Sunt et enim eaque totam ea iste. Voluptas molestiae minima provident cupiditate. Quos dolores quia accusantium ad in. Cum perspiciatis laborum error et officiis earum maxime.
Quas sapiente numquam voluptatum et a. Quo iste voluptatem autem omnis omnis placeat. Sit qui rem autem neque.
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...