New Vs existing based on conditions: name, date|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello!

I have a large spreadsheet(80K + rows) and I am trying to create a marker cell that will tell me if the a given username is new or existing.

If the name is entered for the first time, and have it be labeled as "NEW" based on its timestamp, if there has been a previous entry with the same name, I need to show as "Existing".

I am currently using a =IF(MINIFS(C$2:C$100000,K$2:K$100000,K2)=C2,"New","Existing")

Where:

-Column C = date(where the unit of measure is 1 month, sometimes the same username comes up multiple times in on month, but as long as as it showed up for the first time on that particular month, it is still considered new)

-Column K = name(record that I m comparing against the whole record)

It works, but everytime I open the file it takes a bout 10 minutes to run any action.

I would appreciate if anyone has another approach that could make this faster

Thank you!