thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Hi Guys,
Is there a way to do the following. I basically want to Use the first name from Column C (Name) and populate Column D (Name 2) if the ref in column A is identical to the cell above or below and if column B shows yes. I hope this makes sense. So the formula in column D would look like this:
<colgroup><col width="81" span="4" style="width:61pt"> </colgroup><tbody>
</tbody>
Is there a way to do the following. I basically want to Use the first name from Column C (Name) and populate Column D (Name 2) if the ref in column A is identical to the cell above or below and if column B shows yes. I hope this makes sense. So the formula in column D would look like this:
Ref | Yes or No | Name | Name 2 |
1 | Dave | Dave | |
5 | Yes | Bethan | Bethan |
5 | Yes | Sonia | Bethan |
5 | Yes | Hannah | Bethan |
4 | Ceri | Ceri | |
3 | Hannah | Hannah |
<colgroup><col width="81" span="4" style="width:61pt"> </colgroup><tbody>
</tbody>