Morning all,



I'm having trouble figuring out how to convert my data between two different cancer staging methods. I've included a picture of the tool below so you get an idea.

http://patentimages.storage.googleap...00004_0001.png

Basically, I have the T, N and M data all listed in separate columns and I've used the CONCAT function to combine them because they all affect each other. I'm trying to convert the combined TNM stage to the staging with roman numerals for example:

T1 N0 M0 should become Stage I
T3 N0 M0 should become Stage IIA
T4 N2 M1 should become Stage IV
and so on.....

I've also attached an example set of data that I made I up that is similar to my original dataset: I've removed the wordy parts from the T, N and M categories and then combined them in the end column.

It's fairly complicated question but I can't help but think there must be a simple solution to it all.

Thank you!

Attached Files

Example.xlsx (9.7 KB, 11 views)