Prefer to try this use Excel functions to handle this without VBA. Been trying a few searches, sure the solution is available somewhere. Believe this should be an easy one.
We have three columns for each record and only one of the columns will have a string value of X or no Type defined. Table sample shown below.

Requesting help of a formula that would return a 1 for the first record of Type I value of X, return a 0 for the second record, no Types defined. Return 3 for record 3 of Type III and return 2 for record 4 of Type II, and so on. So, record 5 would return a 1 for Type I.

Any help would be greatly appreciated. Thank you in advance.