Sorting a list into two catagories

[BradM]

Hello, I having trouble with making a simple statement.

I have a list of items that belong in two catagories. The second last character in the item code defines which catagory. is it possible to have a statement that defines whether the item is in catagory a or b.


The trick is that the catagory defining character for an "A" item is either a "P" or "T" and catagory "B" is all other caracters.

ie.

123P6 = "A"
456T2 = "A"
789G1 = "B"
123H5 = "B"

 

[acw]

Hi

This assumes that the data is always in the same format as you have provided ie the determining character is always in position 4 of the string.

=IF(OR(MID(A1,4,1)="P",MID(A1,4,1) = "T"),"A","B")

Tony

 

[BradM]

That is exacly what i needed thank you.