Forum

Notifications
Clear all

New Vs existing based on conditions: name, date

2 Posts
2 Users
0 Reactions
159 Views
(@lightscript)
Posts: 1
New Member
Topic starter
 

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!

 
Posted : 06/06/2019 7:50 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Pablo,

Can you share the file with us?

Phil

 
Posted : 07/06/2019 6:43 pm
Share: