Duplicate Analysis Help

[Steel_Tiger]

I am currently trying to analyze duplicate data and need to do so for over 1500 duplicated items. Below is what I am trying to write a formula to do.....However I am not having much luck...Any help would be greatly appreciated.

1. If Col D & E are the same, return “DELETE” (on one of the lines)
2. If Col D & E are NOT the same, and Col D is greater than Col E for any/all of the duplicate lines, return “REV CK”
3. If Col D & E are NOT the same, and Col D is less than Col E return “OK” for the line that has the greater value in Col D, but still less than Col.E

Thanks to all in advance for any help

[FDibbins]

hi and welcome to the forum

try this (untested)...

=if(D1=E1,"Delete",if(D1>E1,"REV CK","OK"))