Replace Formula

[Ayaanarjun-5885]

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

[aatalai · Accepted solution]

@Ayaanarjun-5885 take a look at this and let me know if it helps

[binuacs · Accepted solution]

@Ayaanarjun-5885 Here is another way

[terry10 · Accepted solution]

@Ayaanarjun-5885 , Here's another way you can accomplish this using the Switch function. I hope this is useful!

[terry10]

Be sure to check your results when using the Find-Replace tool. Sometimes the output is not what's expected.