i have a bunch of the columns, one of them labels the stock to be either Long or Short. if i want to put all the long in one tab and all the short in another tab, so i can reference them separately from there on, what formula should i use so it updates automatically when the first sheet refreshes? No macro please. thanks in advance!
Trending Content - Investment Banking Forum
| +139 | Restructuring: Anti-climactic Experience | 36 | 8h |
| +110 | IB Net Worth / Savings Check | 51 | 7h |
| +100 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 5h |
| +80 | Stop sleeping on UBS - it’s pretty good | 29 | 4h |
| +70 | Hot take: I’d rather be at Desjardins than UBS for investment banking in 2026 | 13 | 11m |
| +56 | 2026 VAULT PRESTIGE RANKINGS | 30 | 1h |
| +39 | AI + Financial Modelling | 12 | 1d |
| +32 | Hardest interview experiences? | 20 | 1h |
| +28 | Summer before college | 17 | 19h |
| +26 | Current State of UBS in North America | 8 | 2d |
Career Resources
man, I'm so bored I was gonna write you a macro but you don't want them so...
nah i can write a macro, but i want to know how to do it by formula, can you help?
sort by the long/short column and then cut and past. am i missing something here?
Make a table, then sort. That way you have all the long and short ones grouped together. Paste the short ones to a new sheet.
can't copy and paste because the data could get refreshed. want everything to be linked.
I am not quite sure how you have referenced the cells, if you can elaborate on that, I might be able to help out.
Try this. Create a new sheet. Now suppose column G mentions long or short. Go to the new sheet and type this formula. (Let's assume your current tab is called AS) if(AS!G1="long",G1,""). You can extend this across the row. Now you will get a list with all the long values, with rows missing for the short ones, go on and delete those if you like. DO the same for short.
maybe reorder your table (by linking) and then utilize a Vlookup?
AK47_47: that's what I tried first, is there a way that leaves no space between the rows?
Either you sling crack rock or you got a wicked jump shot
vlookup doesn't work, or why would i bother posting. with problem with vlookup is that the same row could be repeated, unless i'm missing something.
Do what someone said above with copying it to another sheet.Paste special and then copy values so the data doesn't get refreshed.
Repudiandae id corrupti eum voluptatibus. Molestiae hic molestias explicabo placeat consequatur ea. Natus sequi illum ut consequuntur nihil sed.
Facere veniam quia adipisci voluptatem rerum eaque qui. Recusandae ullam nostrum sed modi repellendus. Necessitatibus ea qui sit eos voluptates et nihil.
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...