Hi Team, I have three columns lets say Name, Count of duplicate and Moved to tracker (Yes/No).
Requirement: If count of duplicate is 1 then Moved to tracker as "Yes" and If count of duplicate is >1 Moved to tracker as "No"
Description: Let say initially Name = "Leela" so count of duplicate = "1" as per my formula Moved to tracker coming as "Yes". When new entry Leela comes, count of duplicate for both the names = "2" as per my formula for both the names moved to tracker coming as "No" as count of duplicate became >1. I want that first one "Leela" should be remain as "Yes" and the new entry should be "No" in Moved to tracker column.
What is the way to overcome this issue?
