How would I create this formula to be applied to Column C (returning a boolean)?
If B2 contains “apple”, see if the number in A2 exists in any other A cells whose row doesn’t contain “apple” in the B column. (Assuming other rows also have “apple” in the B column and may or may not have a duplicate number in the A column).