looking age of last non-matching value

I have data that looks like this (three columns: Date, IGN and AP):


8/8/2019 Emxmari0 3560
8/11/2019 Emxmari0 3580
8/12/2019 Emxmari0 3580
8/16/2019 Emxmari0 3590
8/17/2019 Emxmari0 3590
8/21/2019 Emxmari0 3590
8/22/2019 Emxmari0 3590
8/23/2019 Emxmari0 3590
8/24/2019 Emxmari0 3590
8/28/2019 Emxmari0 3590
8/31/2019 Emxmari0 3590


I would like to create a new column AGE that when looking up the last value for the IGN column (just showing Emxmari0 in this case) I would like to look up the AP (3590) for last row of the given IGN (the 8/31/2019 date) and then look backwards in time to find the row for the given IGN with a different value in the AP column (the 8/12/2019 date vas a value of 3580), then with the two rows identified give the difference in days using the A column, 19 in this case.  If a row for a given IGN isn’t the last row (which presumes the highest date) then the value for AGE would be blank.

Any help toward figuring this out would be appreciated!

By: Joel Breazeale

1,240 thoughts on “looking age of last non-matching value

  1. Phentermine online kaufen

    I have been surfing on-line more than three hours these days, but I never discovered any attention-grabbing article like yours. It is lovely price enough for me. In my opinion, if all website owners and bloggers made just right content material as you did, the net will be much more useful than ever before.

  2. Assistir Record No Celular

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. Android Iptv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  4. презентация по математике 3 класс школа россии по учебнику моро

    Hey there! I know this is kind of off-topic however I had to ask. Does operating a well-established website such as yours take a massive amount work? I am completely new to operating a blog but I do write in my journal every day. I’d like to start a blog so I will be able to share my personal experience and feelings online. Please let me know if you have any ideas or tips for new aspiring blog owners. Appreciate it!| а

  5. Huruf Timbul

    Some us know most concerning the compelling channel you present powerful methods on your blog and consequently strongly encourage contribution through other ones on this kind of subject while our very own child is actually discovering a new great deal. Have enjoyment with the rest of the portion involving the year.

  6. 출장서비스

    You can definitely see your enthusiasm in the work you write. The world hopes for more passionate writers like you who are not afraid to say how they believe. Always go after your heart.

  7. CN Gadget

    I truly appreciate this post. I ave been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thank you again

  8. Lacresha Goolman

    Have you ever considered about adding a little bit more than just your articles? I mean, what you say is important and everything. Nevertheless think about if you added some great photos or videos to give your posts more, “pop”! Your content is excellent but with images and video clips, this website could definitely be one of the most beneficial in its niche. Wonderful blog!

  9. jordans

    I just wanted to send a simple message in order to express gratitude to you for the unique steps you are showing on this site. My prolonged internet lookup has finally been rewarded with good know-how to share with my good friends. I ‘d say that most of us visitors are really fortunate to live in a really good network with so many awesome people with valuable tricks. I feel truly happy to have seen the web pages and look forward to tons of more fabulous moments reading here. Thanks a lot once again for a lot of things.

  10. kaufen sie orale anabole steroide

    This blog is definitely rather handy since I’m at the moment creating an internet floral website – although I am only starting out therefore it’s really fairly small, nothing like this site. Can link to a few of the posts here as they are quite. Thanks much. Zoey Olsen

  11. Buy Reductil Europe

    I’ll immediately clutch your rss feed as I can not in finding your e-mail subscription link or e-newsletter service. Do you have any? Kindly permit me recognise in order that I may subscribe. Thanks.

  12. Comprar Fentermina en línea

    Today, I went to the beach front with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  13. Acquistare Phentermine

    hi!,I like your writing very much! share we communicate more about your article on AOL? I need an expert on this area to solve my problem. Maybe that’s you! Looking forward to see you.

  14. Acquistare Melanotan 2 in linea

    After study a few of the blog posts on your website now, and I truly like your way of blogging. I bookmarked it to my bookmark website list and will be checking back soon. Pls check out my web site as well and let me know what you think.

  15. Acquistare Melanotan 2 in linea

    Hi, just required you to know I he added your site to my Google bookmarks due to your layout. But seriously, I believe your internet site has 1 in the freshest theme I??ve came across. It extremely helps make reading your blog significantly easier.

Comments are closed.