Manual document processing could be a reason behind your business losing money along with your staff losing interest in their commitments. The easiest way to speed up all organization operations and enhance your statistics would be to deal with everything with cutting-edge solution like DocHub. Deal with your files and Save Sales Representative Agreement in Excel within seconds and save more time for pertinent tasks.
With DocHub, you possess limitless access to your files and Templates available for you at any time. Explore all functions right now with the free DocHub account.
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