View Single Post
 
Old 05-18-2020, 02:02 AM
Ch0pe5 Ch0pe5 is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: May 2020
Posts: 3
Ch0pe5 is on a distinguished road
Default Converting data using medical staging tools that come in a table form

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
File Type: xlsx Example.xlsx (9.7 KB, 8 views)
Reply With Quote