Having comprehensive control over your files at any moment is essential to relieve your day-to-day tasks and increase your productivity. Accomplish any objective with DocHub tools for document management and practical PDF file editing. Access, change and save and integrate your workflows with other protected cloud storage services.
DocHub provides you with lossless editing, the chance to use any format, and securely eSign papers without searching for a third-party eSignature option. Make the most of the file managing solutions in one place. Try out all DocHub capabilities today with the free profile.
were gonna Excel magic trick number 697 okay if you want to download this workbook and follow along click on my YouTube channel then click on my college ups at Lincoln you can download the workbook I feel magic trick 686 to 697 and this trick here we need to extract records by a criteria year and month now these are serial numbers so we cant just use this criteria to extract that we have to do something to this to get it to equate to this column here now were gonna do two methods here one is filter and thats just you should do that most of the time its just quick and easy but if you need something dynamic then well look at a formula hey lets do filter click in one cell on the data set and in earlier versions you use the keyboard shortcut alt D F F and then it adds these alt D F F is a toggle so it toggles them off and on shift ctrl shift L works in later versions now in earlier versions you had to click on this and I dont have it here and point to custom and then do an and you