Please enter an Excel formula (Column B) to separate data according to the ff:

Using IF function

Column A

56351655

56351659

55995698SC

R56351661

56351657

56351652

56351653

56351651

56351660

56351651SC

56351656

56351654

56351650

56351658

180101_PROVISION_FOR_RECEIVABLES

56420423

i.return "PMT" if Column A contains a normal invoice number

ii.return "Co-Op" if Column A contains a number with the following format

Ex: 2520-152851155

iii.return "Co-Op Reversal" if Contains a Co-Op ending with "R1"

Ex: 2500-151881120R1

iv.return "SC / SCR" if Column A contains an invoice number that ends in SC or SCR.

Ex: 56677529SCR