Hi,
I ran into a situation where a NL() filter needs to filter in anything contains number in cell G5. Example will be: G5=105795, filter is looking for anything contains 105795. It can be "Manifest# 105795", also can be "PO# 105795". Or just 105795.
I have tried to combine wild card (*) with G5 but not succeed yet.
Does anyone knows the possible solution?
Thanks.
Regards.