Duplicate finder formula field using VLOOKUP

This is great help from salesforce to find dups without any trigger OR SOQL involved.

FORMULA:

	AND(
	Name = VLOOKUP($ObjectType.pradeep_dani__Live_Agent_Status__c.Fields.Name , $ObjectType.pradeep_dani__Live_Agent_Status__c.Fields.Name, Name ),
	NOT(
	Id = VLOOKUP($ObjectType.pradeep_dani__Live_Agent_Status__c.Fields.Id , $ObjectType.pradeep_dani__Live_Agent_Status__c.Fields.Name, Name )
	)
	)

view raw DUP_VLOOKUP hosted with ❤ by GitHub