Hi,
I have two columns ID & ID-2 (column D & E in attached sample data). I need the formula in column G which gives a concatenated value from col D & E screening multiple row values from the same columns.
Please refer the attached sample data to understand the requirement better.
The formula should consider all the below scenarios and populate the desired result based on the scenario it identified in the data.
Scenario 1:
All the values in column D & E of that customer are the same. No need to bring in the customer column into the formula as no two customers will not have the same ID numbers.
Desired result: Don’t require concatenation as the ID did not get changed in all the 4 row items as shown in the sample data
Scenario 2:
All the values in column D & E of that customer gets changed in all the four row items.
Desired result: Concatenated ID should include all the distinct values from those two columns (D & E) of that customer in all the row items of that customer.
Scenario 3:
Only few values in column D & E of that customer gets changed.
Desired result: Concatenated ID should include all the distinct values from those two columns (D & E) of that customer in all the row items of that customer.
Regards,
N
Bookmarks