good day sir! watching from the Philippines. I'd like to ask if you also a tutorial like this on the video that when customer is found, details of the customer will list/add to another blank table? thank you..
Awesome tutorial Sir. I did not understand the reason why you have wrapped the filter function in Not() and iserror(). I could not understand why you prefer the find() which is case sensitive, over the search(). Anyway, it was great to walk us trough the logic of building the nested if() in order to accommodate specific conditions and options. Keep doing and sharing great work!
feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria. U this is simple search, not advance search LOL
I've been looking scrolling up & down to kind this kind of formula. Thank you so much!
Welcome 🙏
good day sir! watching from the Philippines. I'd like to ask if you also a tutorial like this on the video that when customer is found, details of the customer will list/add to another blank table? thank you..
Awesome tutorial Sir. I did not understand the reason why you have wrapped the filter function in Not() and iserror(). I could not understand why you prefer the find() which is case sensitive, over the search(). Anyway, it was great to walk us trough the logic of building the nested if() in order to accommodate specific conditions and options. Keep doing and sharing great work!
feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria. U this is simple search, not advance search LOL