rentonhighlands
Board Regular
- Joined
- Jul 31, 2014
- Messages
- 110
Members:
Please help me write a formula
Sample Data
A B
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
If column A finds a match on IP address and column B has both 1_V & 2_V then say YES in column C otherwise NO
I want to find in column A if there is the same IP address and it has both 1_V and 2_V I want Yes
Please help me write a formula
Sample Data
A B
1.1.1.1 | 1_V |
1.1.1.1 | 2_V |
1.1.1.2 | 1_V |
1.1.1.3 | 1_V |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
If column A finds a match on IP address and column B has both 1_V & 2_V then say YES in column C otherwise NO
I want to find in column A if there is the same IP address and it has both 1_V and 2_V I want Yes