Hello friends,
I want to check TRx in column 2, if only TRx there then I want check column 1 value, whether that cell have “Aggregrate” word available or not.
For eg.
If My bot find “TRx” in G2, then bot will check in G1 for “Aggregrate” word available or not. If available then it will capture G3 value else it will check next column.