Getting comprehensive control over your files at any moment is vital to relieve your everyday tasks and improve your productivity. Accomplish any objective with DocHub features for document management and convenient PDF file editing. Access, change and save and incorporate your workflows with other safe cloud storage services.
DocHub offers you lossless editing, the chance to use any format, and securely eSign papers without searching for a third-party eSignature alternative. Get the most of the file managing solutions in one place. Consider all DocHub capabilities right now with your free of charge account.
welcome to Excel magic trick number 1382 hey if you want to download this excel workbook EXO metric 1382 start or the finished file so you can follow along click on the link below the video we got a great video here we got to talk about how to extract records with multiple contains or partial text criteria now were going to have three examples well see filter advanced filter with formula criteria and an array formula okay heres our data set and for each record we have a potential employee with a bunch of information but the column were interested in is job title we actually need to find any record that contains the word data Analects bi business intelligence Dax PowerPivot or machine learning if we were doing this manually wed have to check each one performing an or logical test on each job title for each record we would have to ask the question does this job title contain the text data or analytics or b.i or any of the other items in this list and wed have to do that for every