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
| +137 | Return Rates For Interns Are Falling? | 44 | 5h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 3d |
| +73 | London IB BB is a challenge | 40 | 4h |
| +71 | I am a drunk MD AMA | 33 | 5h |
| +61 | VP Lifestyle at Top BB Coverage Groups | 39 | 2h |
| +46 | SharePoint makes IB hours HELL | 15 | 1d |
| +46 | An Outsider’s View of RX Banking Out of College | 6 | 1d |
| +42 | momentum of Rx groups | 15 | 5h |
| +39 | Fired during interview | 8 | 9h |
| +28 | Weird Majors->IB ? | 22 | 2h |
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.
Qui natus debitis hic quisquam. Qui qui ipsa quibusdam nihil accusantium quasi amet. Saepe eos iusto iure molestias.
Sed corporis molestias magnam excepturi fugiat. Fuga omnis minima sit facere. Deleniti mollitia aut quasi aspernatur blanditiis dolores aut. Debitis fuga nam iure eius molestias qui.
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...