rodney plonker

<div>
<div class="content wysiwyg-content fr-view">
<p>Hi&nbsp;</p><p><br></p><p>I have a workbook that finds missing data no problem but now im trying to add duplicates to it.</p><p>What im trying to do is get it to look down columns I-L and if any duplicated issues I need one of them marked DUPLICATE in column O for one of the entries.</p><p><br></p><p>Any Ideas?</p><p><br></p><p><a href="https://filedb.experts-exchange.com/incoming/2023/10_w43/1625815/TEST--12--ans1--1-.xlsx" class="fr-file" rel="ugc">TEST (12) ans1 (1).xlsx</a></p>
</div>
</div>


TEST--12--ans1--1-.xlsx


Hi 
I have a workbook that finds missing data no problem but now im trying to add duplicates to it.
What im trying to do is get it to look down columns I-L and if any duplicated issues I need one of them marked DUPLICATE in column O for one of the entries.
Any Ideas?
TEST (12) ans1 (1).xlsx

Need help trying to add another formula to a workbook.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.