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
| +341 | Evercore Intern Seizure | 53 | 8m |
| +59 | JPM M&A is Gone??? Purely Coverage Banking??? | 27 | 1h |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 3h |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +32 | Incoming IB Analyst: Best Ways to Prepare? | 10 | 1h |
| +30 | How do I understand vs. just memorizing? | 5 | 1h |
| +27 | Which groups are ideal for laterals? | 12 | 3h |
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.
Molestias fugit vero omnis. Inventore consectetur rerum earum rerum est vitae. Aspernatur asperiores rerum praesentium nemo dolorem hic nisi. Laboriosam eum ipsam omnis ad odit suscipit laudantium labore.
Itaque vel sed qui aspernatur. Ipsam quaerat aut vitae enim vitae quasi. Sint consectetur vel doloremque. Commodi doloribus facilis assumenda est dolores vitae cupiditate. Autem nam maiores assumenda sed.
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...