Comparing identical ID in 2 consecutive rows and then set condition to compare other column values in same row

Hi, i have 2 rows with same ID, i want to compare the columns start date or months, when teh ID matches, i want the result as those whose start date is greter/ months is greater.

Which formula can i use here?

 

Thanks in advance.

 

 

individual_id months start_date Result
63381438 209 2002-02-01  
63381438 213 2001-10-25 Is registered First
63427662 43 2015-12-01  
63427662 144 2007-07-12 Is registered First
63458321 86 2012-05-16  
63458321 340 1991-03-01 Is registered First
63468084 39 2016-04-26  
63468084 43 2015-12-21 Is registered First

By: Prav

Leave a Reply

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