<div>
No need for VBA<br />
<br />
=IF(COUNTIF($E$2:$E2,$E2)=<wbr />0,1,0)<br />
<br />
Copied down as far as required.<br />
<br />
Thanks<br />
Rob H
</div>


No need for VBA

=IF(COUNTIF($E$2:$E2,$E2)=0,1,0)

Copied down as far as required.

Thanks
Rob H

<div>
@Rob<br />
<br />
If I am not wrong, tt should be like this.....<br />
<br />

<pre><code id="code-20-40908148-1">=IF(COUNTIF($E$2:$E2,$E2)=1,1,0)</code></pre>
</div>


@Rob

If I am not wrong, tt should be like this.....



=IF(COUNTIF($E$2:$E2,$E2)=1,1,0)

<div>
This is perfect Thank you so much!!
</div>


<div>
You're welcome. Glad it worked as per your requirement. :)
</div>


You're welcome. Glad it worked as per your requirement. :)

<div>
Sktneer - correct, I omitted to offset by a row to count the cells above.
</div>


Sktneer - correct, I omitted to offset by a row to count the cells above.

<div>
<div class="content wysiwyg-content">
I need a macro that would assign a 1 to the first value and a 0 to each additional value that is the same. IE<br />
<br />
Apple &nbsp;1<br />
Apple &nbsp;0<br />
Apple &nbsp;0<br />
Orange 1<br />
Banana 1<br />
kiwi 1<br />
Banana 0<br />
<br />
Searching Column E and Put the value in Column N start at row 2. <br />
<br />
Thanks,<br />
Montrof
</div>
</div>


I need a macro that would assign a 1 to the first value and a 0 to each additional value that is the same. IE

Apple  1
Apple  0
Apple  0
Orange 1
Banana 1
kiwi 1
Banana 0

Searching Column E and Put the value in Column N start at row 2. 

Thanks,
Montrof

Add a Value for first value in Column

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