Avoid Duplication in Column with Matching

Fabric # Reel # Remarks
190 Reel 1 ok
190 Reel 2 ok
190 Reel 3 ok
190 Reel 1 Narration comes that this entry already exist

Respected Genies,

i just highlight the duplication. it is not necessary that it will always last entry which will compare with the all the above entries. I need that if i change in any column, then the entry will compare with the above and below entries.

See if this is a solution for you; using Data Validation.
See sample workbook!