Having complete control over your documents at any time is vital to ease your everyday tasks and improve your productivity. Accomplish any objective with DocHub tools for papers management and hassle-free PDF file editing. Access, change and save and incorporate your workflows along with other safe cloud storage.
DocHub gives you lossless editing, the chance to work with any format, and safely eSign documents without having searching for a third-party eSignature option. Maximum benefit from the document management solutions in one place. Consider all DocHub capabilities right now with your free of charge profile.
welcome to Excel magic trick number 878 if you want to download this workbook click on the link below the video in our last video eight seven seven we had some managers and some salespeople we wanted to be able to just select this manager Dave have the sales reps come up here and extract these records from over here so in this video eight seven eight were going to add one more level of criteria were still gonna have to look for Dave we need these three salespeople heres our data set however we also have an additional criteria we need to find product so only sales rep and these product if Bob sold any of these three products then we want to extract that record now this is going to be an or and and criteria so as we look through the salesperson column over here a salesperson were asking the question and lets see we have three names Bob Mike Pete is that Bob Mike or Pete were never gonna get more than one answer here but its an or is that Bob or is it Pete or is it Mike or whateve