<div>
namaste, Subodh - thank you
</div>


<div>
Namaste Crystal! :)<br />
You're welcome.
</div>


<div>
My apologies for the delay and thank you both for your quick responses<br />
The suggested points distribution is certainly fine with me.<br />
Dave
</div>


<div>
you're welcome, Dave ~ happy to help<br />
धन्यवाद, Subodh (not sure of your dialect -- Google helped me)
</div>


<div>
The chosen answers resolved the question.
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
I would like to populate one cell (A1) with '*' if a range of 5 other cells (B1:B5) contain at least one instance of 'yes' and at least one instance of 'no'. &nbsp;As an example, if B1 = yes, B2 =yes, B3=no, B4=yes, B5=yes then A1=*<br />
Thanks for your help
</div>
</div>


Hello
I would like to populate one cell (A1) with '*' if a range of 5 other cells (B1:B5) contain at least one instance of 'yes' and at least one instance of 'no'.  As an example, if B1 = yes, B2 =yes, B3=no, B4=yes, B5=yes then A1=*
Thanks for your help

I would like to populate one cell (A1) with '*' if a range of 5 other cells (B1:B5) contain at least one instance of 'yes' and at least one instance of 'no'.

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