Replace Formula

Question

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=1XYZ=2PQR=3UVW=4

Input:

IDsABC,XYZPQR PQR,ABC,UVWUVW,PQRXYZ,PQRABC

Output:

IDsReplacing IDs with referred valuesMin valueABC,XYZ1,21PQR 33PQR,ABC,UVW3,1,41UVW,PQR4,33XYZ,PQR2,32ABC11

aatalai · Accepted Answer

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

binu_acs · Accepted Answer

@Ayaanarjun-5885 Here is another way

terry10 · Accepted Answer

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