Hello
I need a formula to pull certain text from a string,
IN Col AA there a formula that's working of sorts, however, I need the formula to be dynamic enough to recognize each of the below text
COV
RHL
LHL
N/L
A205
It also needs to look at the pallet number in COL X,
please see attached to help to understand..
thanks for looking
Bookmarks