GingaNinga
New Member
- Joined
- Sep 1, 2017
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Hello - first- thank you experts for your help.
I am having trouble articulating what I am trying to accomplish, but I will give it a shot.
I am trying to return a specific value in a column based on two conditions.
Condition 1: If the Unique Display ID is the same
Condition 2: If the sum of TL Gum Displays is greater than 1
Result: Unique Gum column would return a value of 1
Example of expected result:
<tbody>
</tbody>
A few additional things - I don't care in which row the value of 1 appears for Unique Gum, and where it equals 0, I don't care if that is a 0 or a blank.
I am having trouble articulating what I am trying to accomplish, but I will give it a shot.
I am trying to return a specific value in a column based on two conditions.
Condition 1: If the Unique Display ID is the same
Condition 2: If the sum of TL Gum Displays is greater than 1
Result: Unique Gum column would return a value of 1
Example of expected result:
Unique ID | TL Gum | Unique Gum |
123 | 1 | 1 |
123 | 0 | 0 or blank |
123 | 1 | 0 or blank |
<tbody>
</tbody>
A few additional things - I don't care in which row the value of 1 appears for Unique Gum, and where it equals 0, I don't care if that is a 0 or a blank.