Hello,
I have created a spreadsheet for my team to keep track of batch programs that are being ran. There are 100 cells (C2:C101) on Sheet1 where they can enter their batches. Multiple batches look something like this:
BI-EBTDM-DLY, BI-SNDDM-DLY or IN-PRSDX-MLY, IN-RCSDX-MLY, IN-MEDF-DLY
There...