Hi, I have few IDs and I wanted to replace them using single formula tool with below referred values and extract the min value in another new column. Can someone help me with this. Replacement values are,
ABC=1 |
XYZ=2 |
PQR=3 |
UVW=4 |
Input:
IDs |
ABC,XYZ |
PQR |
PQR,ABC,UVW |
UVW,PQR |
XYZ,PQR |
ABC |
Output:
IDs | Replacing IDs with referred values | Min value |
ABC,XYZ | 1,2 | 1 |
PQR | 3 | 3 |
PQR,ABC,UVW | 3,1,4 | 1 |
UVW,PQR | 4,3 | 3 |
XYZ,PQR | 2,3 | 2 |
ABC | 1 | 1 |
Solved! Go to Solution.
@Ayaanarjun-5885 Here is another way
@Ayaanarjun-5885 , Here's another way you can accomplish this using the Switch function. I hope this is useful!
Be sure to check your results when using the Find-Replace tool. Sometimes the output is not what's expected.