Categories based on the character

[SH_94]

Hi community, 

i would like to ask how to make the categories below based on the input.

The logic will be as follows:

If the first character of the company code start with from A till H, it will be mapped under AH series. if the first character fall under I to R , then it will be mapped under IR series. If the first character from S to Z, then it will be mapped under SZ series.

Many thanks in advance.

[binuacs · Accepted solution]

@SH_94 

[rzdodson]

@SH_94: @aatalai is spot on. Initially, when you do a ChartoInt formula, it'll convert A to 65, B to 66, etc. To get it back to its desired value, I subtracted 64 so we can get the numbers aligned to the letter.

As a note, if any of the solutions provided by @binuacs or myself solved the use case, please go ahead and mark them as solutions to make it easier for others to find if they run in to something similar. :)