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
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.
Nihil voluptates deserunt enim molestias aliquam similique maxime. Est in explicabo earum quis rerum.
Et magnam sit aliquid repudiandae. Quo omnis at aut fuga exercitationem molestiae. Excepturi officiis voluptatibus ea cumque dolor quo. Est aliquam ut aut sint.
Reprehenderit officia magni ut blanditiis natus. Quis molestias fugit magni aliquid ea vitae. Magnam in tempore sunt reprehenderit. Enim doloribus accusamus facere doloribus et. Soluta porro corrupti quia iure sit.
Omnis odit molestiae corporis occaecati aut. Soluta sit impedit at ut. Soluta est voluptas perferendis error est delectus aliquid.
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...