Hi guys,
I want to filter part of a field which is separated by a wild character. In my scenario this is separated by ";".
Example:
BG_1234_P;Spare-parts
Filter based on the part of the field in bold.
In order to find the actual part of the field (in my case this is the "Description" field), I use the formula below:
=LEFT(I9;FIND(";";I9)-1)
The problem is incorporating this in my formula because, 1) I want to filter only part of the field which is easy as I use the formula above as my filtering value and 2) how do I reduce the data I want to be matched with in my field which is the hard part.
I have read the thread below that didn't work. Maybe because I'm trying to fit a nested excel formula in JET and messes up.
Thanks!