Hi Team,
I have two list of transaction ID. Compare it and Extract Unique Values.
Column A , Old list of transaction ID
Column B , New list of transaction ID
Colum C is a expected output. how to extract using Unique values using dictionary or any other method. Thanks.
Below is Table with expected output. Thanks.
Thanks
mg
I have two list of transaction ID. Compare it and Extract Unique Values.
Column A , Old list of transaction ID
Column B , New list of transaction ID
Colum C is a expected output. how to extract using Unique values using dictionary or any other method. Thanks.
Below is Table with expected output. Thanks.
Book6 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Old Transaction ID | New Transaction ID | Unique Data | ||
2 | 11173 | 11173 | 11246 | ||
3 | 11175 | 11175 | 11239 | ||
4 | 11183 | 11183 | 11247 | ||
5 | 11185 | 11185 | 11260 | ||
6 | 11215 | 11215 | 11257 | ||
7 | 11217 | 11217 | 11257 | ||
8 | 11225 | 11246 | 11259 | ||
9 | 11231 | 11239 | |||
10 | 11247 | ||||
11 | 11185 | ||||
12 | 11260 | ||||
13 | 11257 | ||||
14 | 11183 | ||||
15 | 11257 | ||||
16 | 11259 | ||||
17 | 11231 | ||||
Sheet1 |
Thanks
mg