looking age of last non-matching value

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

 

Date IGN 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,045 thoughts on “looking age of last non-matching value

  1. dk eyewitness travel guide

    Fascinating blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your design. Thanks

  2. digital agencies in andheri

    It’s a shame you don’t have a donate button! I’d definitely donate to this brilliant blog! I suppose for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to fresh updates and will talk about this website with my Facebook group. Chat soon!

  3. converse

    I must get across my love for your generosity supporting men who really need guidance on this particular theme. Your very own dedication to getting the solution up and down had been exceptionally insightful and has specifically helped guys and women much like me to realize their dreams. Your new important key points means a whole lot to me and somewhat more to my office colleagues. Many thanks; from all of us.

  4. твороженные рецепт

    Just want to say your article is as amazing. The clarity in your post is just nice and i could assume you’re knowledgeable in this subject. Well with your permission let me to clutch your RSS feed to stay up to date with imminent post. Thank you a million and please continue the enjoyable work.| а

  5. kemampuan content writing

    Hello, there. I am aware this kind of is off-topic, but I got wondering which blog program are you using regarding this site? I’m having fed up of Live journal because I’ve had issues with hackers and I am just looking at options with regard to another platform. I might be fantastic in the event you can point me in the direction of some sort of good platform.

  6. our website

    Very interesting subject , thanks for putting up. It is much easier to try one as hand at many things than to concentrate one as powers on one thing. by Quintilian.

  7. cbd for athletes

    wonderful post, very informative. I’m wondering why the other
    experts of this sector don’t notice this. You should proceed your writing.
    I’m sure, you have a huge readers’ base already!

  8. cbd for athletes

    What i don’t understood is in reality how you are not really a lot
    more neatly-appreciated than you may be right now. You’re
    very intelligent. You recognize thus significantly on the subject of this subject,
    made me individually consider it from so many varied angles.
    Its like men and women are not involved except it’s something to do with Girl gaga!
    Your individual stuffs outstanding. All the time deal with it up!

  9. welkom bonus zonder storting

    slots gokkast , 5 euro casino storten – zeus gratis gokkast spelletjes : holland casino vestigingen nederland .

  10. geld overmaken ing zonder tan code

    free casino games spelen , slots gratis geld – mr green betrouwbaar casino : puzzelwoordenboek gokautomaat .

  11. holland casino venlo nieuwe locatie

    de brasserie holland casino amsterdam menu , online casino in nederland – review holland casino rotterdam : holland casino venlo niederlande .

  12. gokken nl gratis

    fruit fest gokkast spelen , hoogste jackpot holland casino – gratis slots spelletjes spelen : holland casino geldverwerking .

  13. tips voor casino

    fruitautomaten spelletjes , aantal gokkasten las vegas – sir jackpot casino betrouwbaar : reel cash gokkast gratis spelen .

  14. casino slots spelen

    online casino gewonnen , gratis speelautomaten spelen amsterdams casino – golden oldie gokkast gratis : holland casino utrecht nieuwe locatie .

Leave a Reply

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