The Grim Discovery
Board Regular
- Joined
- Jan 23, 2015
- Messages
- 241
- Office Version
- 365
- Platform
- Windows
A | B | C | |
1 | Reference | Eligible | |
2 | ABC | Yes | |
3 | 123 | Yes | |
4 | DEF | No | |
5 | 123 | ||
6 | 123 | ||
7 | GHI |
<tbody>
</tbody>
Can anyone help me with the following problem.
If a value in Col A is repeated elsewhere in Col A I'd like its corresponding cell in Col B to be automatically populated. In this instance cells B5 & B6 should populate with a 'yes' because of the data in Row 3. Col A could contain an almost infinite range of references - many of which wont duplicate but some will.
Thanks in advance.