title: Complicated Find row in duplicate show which column A or B or C
body: <p>Could you please help me for below formula little bit complicated
  Problem is
  In a sheet I have three column A,B,C any one column amount if it is same in D column need to highlight and show which column A or B orC..
  Example</p>
  <pre><code>A B C D amount in each row
  4 5 7 4 please highlight bez a and d match 
  </code></pre>
  <p>Next example
  5 3 6 2 should not highlight show error msg</p>
  <p>In above case D is matching same number with AorBorC
  Please help me this logic formula</p>
  <p>Formula</p>
  <p><code>=If(countif(A1:d4)=1, &quot;duplicate&quot;,&quot;unique&quot;)</code></p>
  <p>working fine but is there any possibility to show which cell column A or B or C  ... If duplicate which column need to mention</p>
  <p>Much appreciated for this complicated formula am not sure whether it required VBA here</p>