Find Specific String in Row and add to column on left hand side

Hi, I am working on a production schedule file. A company is producing batches of product and each batch goes through three different processes. Each color represents a new process and GP/SP/RP represents a different location of the batch. I am wanting to have excel generate in a column on the left hand side which GP/SP/RP is being used for the specific batch (hopefully with a function). See photo.

For example, Batch 1640 will have separate columns on the left hand side that state GP2, SP1, and RP12 are in use.

I have a function that I created to count the colors in a row and total them on the left hand side. This is what I am wanting but for the exact string name. Below I have pasted the count color function I created as reference.

Function countcolor(rangedata As Range, criteria As Range) As Long
Dim datax As Range
Dim xcolor As Long
xcolor = criteria.Interior.ColorIndex
For Each datax In rangedata
If datax.Interior.ColorIndex = xcolor Then
countcolor = countcolor + 1
End If
Next datax
End Function

This will count the number of GP's in the row not generate which GP is in use. I am looking to generate which GP is being used and put the entire string (i.e. GP*) in a left hand column.

I have attached the file in question.

The columns that are going to be generated are columns E, F, and G, highlighted in yellow. E30, F30, G30, in red font, are samples of what I am wanting the output to look like.

This was my problem 2. Ideally, there will be another 3 columns that will specify how many rows have used GP8. So GP8 (5) means this is the 5th time GP8 has been used. Instead of having in brackets, there will be another column that has number of times been used. See new excel for sample of output. Highlighted in orange are the new columns where the output will be stored. In red font, are samples of what the output should look like.

I am unable to post a url. Maybe you could tell me how to cross reference..

If the RP number is seen in the previous rows, it will log in column J how many times it is seen. Same goes for GP and SP.

Hi SSJ3, if you are using the horse and track number for your reference only, then inserting two columns shouldnt be a problem. Excel will automatically update the formulas for you. Just note that there are some merged cells above the table.

If you are looking to reference the track and horse numbers in the Performance sheet, my recommendation is to use the existing Tipper and Custom variable columns to record this data.