Hi,
I have a large spreadsheet with 2 columns A and B
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
[TD="width: 64"]Name1[/TD]
[TD="width: 64"]Apple[/TD]
</tbody>
I need a way to identify which person (Name) only likes one type of fruit, so in the above example i would like Name1 to be highlighted in some way.
I've spent the better half of the day trying to figure this out and have tried various methods like Match, count, ifs without any luck.
Can someone help me out please?
I have a large spreadsheet with 2 columns A and B
Name1 | Apple |
Name1 | Apple |
Name2 | Apple |
Name2 | Apple |
Name2 | Peach |
Name3 | Pear |
Name3 | Orange |
Name4 | Pear |
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
[TD="width: 64"]Name1[/TD]
[TD="width: 64"]Apple[/TD]
</tbody>
I need a way to identify which person (Name) only likes one type of fruit, so in the above example i would like Name1 to be highlighted in some way.
I've spent the better half of the day trying to figure this out and have tried various methods like Match, count, ifs without any luck.
Can someone help me out please?