Find out duplicate cells or values or entities on google sheets and highlight.

Описание: As shown in this video. How can we easily find duplicate cells of Google Sheets? The solution with that formula is shown in this video.