Optimizing the Formula to run faster Finding the latest record

Hi,

I have a sheet with more than 100k records. Service name is in column B, while the date it was scanned is available in columns j:o.

Formula in
column H will calculate if it is the latest record (based on the date for this service) (=IF(K2=AGGREGATE(14,6,K$2:K$89750/(D$2:D$89750=D2),1),"Yes","No"))
column I will calculate if the record is a latest one in that particular month. (=IF(K2=AGGREGATE(14,6,K$2:K$89750/(D$2:D$89750=D2)/(O$2:O$89750=O2),1),"Yes","No"))

Ex: ABC service would have been scanned for more than 2 years, so that last scan when it was done is calculated in H. irrespective of the month.
ABC service might have multiple scans in a particular month, the latest scan in that particular month is calculated in Column I .

While the formula is correct, the excel sheet hangs up when calculating the records multiple times .

Any operation i do, insert or edit takes huge amount of time and excel freezes, takes more than 8 minutes for just saving the file.

using Excel 2010.

Is there a way this formula can be optimized?

sample sheet is attached.


Appreciate the help.