Calculated column formula to identify and label non specific values in a column based on order

[tjlundquist1]

I am looking for some assistance. I have a list of body shops and appraisers. I want to create a calculated column that identifies and labels them accordingly. Essentially if they are in the order of "Word, Word" I want it to label as an <Appraiser> - all else, <Not an appraiser>.

Any Ideas? 

Body Shop East, 1

Body Shop East, 2

Chris, Kyle

Body Shop East, 3

Body Shop East, 4

Bob, Jim

Body Shop East, 6

[ChrisMendoza · Accepted solution]

@tjlundquist1 -

Maybe something like:

Column =
VAR _right =
    RIGHT (
        Table1[Column1],
        1
    )
RETURN
    IF (
        ISERROR (
            ISNUMBER (
                VALUE ( _right )
            )
        ),
        "Appraiser",
        "Not an Appraiser"
    )

[tjlundquist1]

Works great. Thank you!

[tjlundquist1]

@ChR