In Excel, I am stepping through each row.
I want to check a certain cell, this cell is either empty or not empty (I check if the cell is not empty)
Now my actual quesion:
Cell contents are order numbers, that can start with “TR” or “GT” or “ST” (e.g. “TR123456” or “ST654987”)
- I need to check/read what the two left characters are
- If those are the same as the previous not empty cell (starting row 2)