Djmason2001
New Member
- Joined
- Feb 24, 2020
- Messages
- 14
- Office Version
- 2013
- Platform
- Windows
Good Morning Forum,
Aim : Based on two conditions “Group id(Column B)” and where “Helper (Column C) = 'Master'” I would like to return a value id(Column A) in Column D.
ID : Unique Id
Group Id : is a grouping mechanism to identify that two records should be considered for comparison
Helper : Is a indicator column to determine which id should be returned from Column A based on the GroupId.
I have attached scenarios below
Looking forward to your response
Aim : Based on two conditions “Group id(Column B)” and where “Helper (Column C) = 'Master'” I would like to return a value id(Column A) in Column D.
ID : Unique Id
Group Id : is a grouping mechanism to identify that two records should be considered for comparison
Helper : Is a indicator column to determine which id should be returned from Column A based on the GroupId.
I have attached scenarios below
ID | Group ID | Helper | Outcome | ||
| 21 | Master |
| ||
| 21 | Non Master |
| ||
3333 | 25 | Non Master | 4444 | ||
4444 |
| Master | 4444 |
Looking forward to your response