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

1,485 thoughts on “Excel help

  1. lease beats

    I will right away take hold of your rss as I can not to find your e-mail subscription link or e-newsletter service. Do you have any? Please allow me recognise so that I may subscribe. Thanks.

  2. data sgp

    A motivating discussion is worth comment. I do think that you need to publish more about this subject matter, it may not be a taboo subject but generally people don’t discuss such topics. To the next! Kind regards!!

  3. agen joker 123

    After looking into a few of the blog articles on your web page, I really appreciate your technique of blogging. I added it to my bookmark webpage list and will be checking back soon. Take a look at my website too and tell me how you feel.

  4. situs daftar aduqq

    Right here is the right website for anyone who hopes to understand this topic. You know a whole lot its almost hard to argue with you (not that I actually would want to…HaHa). You definitely put a new spin on a topic which has been written about for decades. Wonderful stuff, just great!

  5. bandar togel

    Oh my goodness! Impressive article dude! Thanks, However I am encountering problems with your RSS. I don’t know why I can’t subscribe to it. Is there anybody having identical RSS problems? Anyone who knows the solution will you kindly respond? Thanx!!

  6. joker123 apk

    Howdy! I could have sworn I’ve been to this website before but after browsing through a few of the articles I realized it’s new to me. Anyhow, I’m certainly happy I found it and I’ll be book-marking it and checking back frequently!

  7. dominoqq

    Having read this I thought it was very enlightening. I appreciate you taking the time and effort to put this short article together. I once again find myself spending a significant amount of time both reading and commenting. But so what, it was still worth it!

  8. romeopoker

    Howdy, I do believe your web site could be having browser compatibility problems. Whenever I take a look at your site in Safari, it looks fine however, when opening in I.E., it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Aside from that, wonderful website!

  9. situs judi online

    A motivating discussion is definitely worth comment. I do think that you need to write more on this subject matter, it may not be a taboo matter but generally people do not speak about these topics. To the next! Kind regards!!

  10. free movies online

    I seriously love your website.. Great colors & theme. Did you create this site yourself? Please reply back as I’m looking to create my own site and would love to learn where you got this from or what the theme is called. Many thanks!

  11. Bulk CBD Oil

    Can I simply say what a relief to search out someone who really knows what theyre talking about on the internet. You undoubtedly know easy methods to convey an issue to light and make it important. More individuals need to read this and perceive this facet of the story. I cant believe youre not more widespread because you positively have the gift.

  12. nonton film

    I must thank you for the efforts you’ve put in penning this site. I really hope to view the same high-grade content from you in the future as well. In fact, your creative writing abilities has inspired me to get my own, personal blog now 😉

  13. www.intan99.net

    Having read this I believed it was rather informative. I appreciate you finding the time and effort to put this informative article together. I once again find myself spending a lot of time both reading and posting comments. But so what, it was still worthwhile!

  14. free movies online

    After I originally commented I seem to have clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I get 4 emails with the same comment. Is there a means you can remove me from that service? Thanks!

  15. kristal66.com

    I blog quite often and I seriously appreciate your content. This article has truly peaked my interest. I’m going to book mark your blog and keep checking for new information about once a week. I opted in for your RSS feed too.

  16. Libby Dao

    Magnificent goods from you, man. I have consider your stuff previous to and you’re just extremely fantastic. I actually like what you’ve received right here, certainly like what you’re stating and the best way by which you are saying it. You are making it entertaining and you continue to care for to stay it smart. I cant wait to read much more from you. This is actually a wonderful web site.

  17. https://herebig99.com/

    wonderful put up, very informative. I wonder why the other experts of this sector don’t notice this. You should continue your writing. I am confident, you have a great readers’ base already!

Leave a Reply

Your email address will not be published. Required fields are marked *