Hi
I am trying the flag "Ration" in the output column based on 2 criteria,
1 Only duplicate values in CCP Name.
2. Corresponding Stock Type for duplicate values has to be 'Inactive - Use Up Inventory" . In below ex. i put the ration where there is duplicate values in CCP Name column and Stock type for both duplicate values is "Inactive-Use Up Inventory". Does anyone had a similar issue and formula that can solve it?
I am trying the flag "Ration" in the output column based on 2 criteria,
1 Only duplicate values in CCP Name.
2. Corresponding Stock Type for duplicate values has to be 'Inactive - Use Up Inventory" . In below ex. i put the ration where there is duplicate values in CCP Name column and Stock type for both duplicate values is "Inactive-Use Up Inventory". Does anyone had a similar issue and formula that can solve it?
CCP Name | Stock Type | Output |
CSA11-BLK | Active - Use Up Inventory | |
CSA11-BLU | Inactive - Use Up Inventory | Ration |
CSAP51-BLK | Inactive - Use Up Inventory | |
CSAP51-BLU | Inactive - Use Up Inventory | |
CSAP51CS-BLK | Inactive - Use Up Inventory | |
CSA11-BLU | Inactive - Use Up Inventory | Ration |