Excel help

Hello,

I need to formulate the following

row A 0 0 0 1 2 3 4 5

Row B Period end              Period end Period end

Row c Date Date Date Date Date 1 Date Date Date 2

 

   

Output Date 1 Date 2 Date 3 etc

What i need is a formuale that looks along row A and finds the cell that contains a 1. Then i need it to look at row B to the right of the column  containing the 1 and find the cell containing the word Period end. One it finds this i need it to bring back the value in the cell below period end in row C.

Once it has brought back the first date (date 1) in need it to be able to be drageed across and kind on move on from the date one and bring back Date 2 etc 

 

Any help would be great. as i cannot crack this one

By: Adam Sloan

2,275 thoughts on “Excel help

  1. 먹튀검증

    It¡¦s actually a nice and useful piece of info. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thanks for sharing.

  2. Women Jackets

    Fantastic goods from you, man. I’ve understand your stuff previous to and you are just too magnificent. I actually like what you have acquired here, really like what you are saying and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I cant wait to read far more from you. This is actually a tremendous website.

  3. cashmere wrap

    Hey just wanted to give you a brief heads up and let you know a few of the images aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different internet browsers and both show the same results.

  4. ps4 games

    Heya i’m for the first time here. I found this board and I find It truly useful &
    it helped me out a lot. I hope to give something back and aid others like you helped me.

  5. Massage Saloon

    Very good website you have here but I was curious if you knew of any message boards that cover the same topics talked about in this article? I’d really love to be a part of community where I can get comments from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Kudos!

  6. Bed assembly service

    Thanks for these guidelines. One thing I additionally believe is credit cards offering a 0% rate often appeal to consumers along with zero interest rate, instant endorsement and easy online balance transfers, however beware of the most recognized factor that can void your current 0% easy neighborhood annual percentage rate and as well as throw anybody out into the bad house rapidly.

  7. Desk assembly service

    I would like to thank you for the efforts you have put in writing this website. I’m hoping the same high-grade web site post from you in the upcoming also. Actually your creative writing skills has inspired me to get my own web site now. Really the blogging is spreading its wings fast. Your write up is a great example of it.

  8. house cleaning Las Vegas

    Greetings! I know this is kinda off topic however I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog post or vice-versa? My website covers a lot of the same topics as yours and I feel we could greatly benefit from each other. If you are interested feel free to shoot me an email. I look forward to hearing from you! Fantastic blog by the way!

  9. Furniture assembly help

    With havin so much content and articles do you ever run into any issues of plagorism or copyright infringement? My site has a lot of completely unique content I’ve either written myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any ways to help reduce content from being ripped off? I’d certainly appreciate it.

  10. i99BET

    Nice post. I learn something new and challenging on blogs I stumbleupon on a daily basis. It will always be useful to read articles from other writers and use something from other web sites.

  11. i99BET

    Everything is very open with a precise explanation of the issues. It was definitely informative. Your website is extremely helpful. Many thanks for sharing.

  12. Furniture installers

    I will right away grab your rss as I can’t in finding your email subscription link or e-newsletter service. Do you’ve any? Kindly allow me know in order that I could subscribe. Thanks.

  13. John Deere Repair Manuals

    hello!,I like your writing so so much! percentage we keep in touch more approximately your post on AOL? I need an expert in this space to unravel my problem. Maybe that is you! Looking forward to see you.

  14. UFABET

    I seriously love your site.. Excellent colors & theme. Did you create this amazing site yourself? Please reply back as I’m wanting to create my own personal blog and want to find out where you got this from or what the theme is named. Many thanks!

  15. Furniture installation team

    Good post. I learn something tougher on completely different blogs everyday. It’ll all the time be stimulating to learn content from different writers and apply just a little one thing from their store. I’d choose to use some with the content on my blog whether you don’t mind. Natually I’ll provide you with a link on your internet blog. Thanks for sharing.

  16. ultimate installation

    Thanks for your write-up. I also believe that laptop computers are getting to be more and more popular currently, and now will often be the only sort of computer found in a household. The reason being at the same time that they’re becoming more and more cost-effective, their processing power is growing to the point where these are as powerful as pc’s from just a few years ago.

  17. logo

    Some truly nice and utilitarian information on this internet site, as well I think the style and design holds excellent features.

  18. udaipur call girls

    My husband and i felt absolutely joyous when John could complete his investigation out of the ideas he made through your web pages. It’s not at all simplistic to simply choose to be releasing methods which a number of people could have been making money from. And we all understand we now have the blog owner to thank for this. Most of the explanations you made, the easy blog navigation, the relationships you will aid to promote – it is many terrific, and it’s aiding our son and us understand the subject is satisfying, and that is highly mandatory. Thanks for all!

  19. i99bet

    Hello there! This article could not be written any better! Looking through this article reminds me of my previous roommate! He constantly kept preaching about this. I’ll forward this information to him. Pretty sure he will have a good read. Many thanks for sharing!

  20. John Deere Service Manuals

    Hello there, just became alert to your blog through Google, and found that it is really informative. I am gonna watch out for brussels. I will be grateful if you continue this in future. A lot of people will be benefited from your writing. Cheers!

  21. i99bet

    I blog frequently and I seriously thank you for your content. Your article has truly peaked my interest. I am going to bookmark your website and keep checking for new information about once per week. I subscribed to your RSS feed as well.

  22. christian louboutin outlet

    Youre so cool! I dont suppose Ive read something like this before. So nice to search out any person with some unique ideas on this subject. realy thanks for starting this up. this website is something that is wanted on the web, somebody with a bit originality. helpful job for bringing one thing new to the web!

  23. Saran Tashjian

    Thanks for taking the time to discuss this, I feel strongly about it and adore learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more details? It is extremely helpful for me.

  24. Bula Murrill

    Can I merely say exactly what a relief to locate somebody who truly knows what theyre talking about on the internet. You definitely learn how to bring an issue to light and produce it important. The best way to need to see this and appreciate this side from the story. I cant think youre no more well-known when you certainly possess the gift.

  25. coconut oil when

    you’re really a just right webmaster. The website loading speed is amazing.
    It kind of feels that you are doing any distinctive trick.

    Furthermore, The contents are masterwork. you’ve done a great process on this subject!

  26. browse this site

    I simply want to mention I am newbie to blogs and absolutely liked you’re web site. More than likely I’m want to bookmark your website . You surely have fabulous posts. Thanks a lot for revealing your web page.

  27. tinyurl.com

    Hmm it appears like your website ate my first comment (it was super long) so
    I guess I’ll just sum it up what I submitted and say, I’m
    thoroughly enjoying your blog. I too am an aspiring blog blogger but I’m still new to everything.

    Do you have any recommendations for newbie blog writers?
    I’d really appreciate it.

  28. tinyurl.com

    Hello are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and set up
    my own. Do you require any html coding knowledge to make your own blog?
    Any help would be really appreciated!

  29. curry 6

    There are some attention-grabbing deadlines on this article but I don抰 know if I see all of them heart to heart. There is some validity but I will take hold opinion till I look into it further. Good article , thanks and we want extra! Added to FeedBurner as effectively

  30. nike air max 97

    There are certainly a variety of details like that to take into consideration. That may be a nice level to bring up. I provide the thoughts above as normal inspiration but clearly there are questions like the one you deliver up the place crucial factor will be working in honest good faith. I don?t know if greatest practices have emerged round issues like that, however I am certain that your job is clearly recognized as a fair game. Both girls and boys really feel the impression of just a moment抯 pleasure, for the rest of their lives.

Comments are closed.