Optimus_Primed036
New Member
- Joined
- Sep 20, 2012
- Messages
- 9
Hi all,
Wondering if anyone can help. I want to count how many times an event occurs. Each event has an individual ID but it can appear many times.
Once established i only want to include those with "IP" in the same row.
For example:
A2=100
A3=100
A4=200
B2=IP
B3=IP
B4=PE
The answer to this should be "1" as there is only one ID (100) with "IP" in same row even though it appears twice.
Hope that made sense.
Wondering if anyone can help. I want to count how many times an event occurs. Each event has an individual ID but it can appear many times.
Once established i only want to include those with "IP" in the same row.
For example:
A2=100
A3=100
A4=200
B2=IP
B3=IP
B4=PE
The answer to this should be "1" as there is only one ID (100) with "IP" in same row even though it appears twice.
Hope that made sense.