Having comprehensive control of your papers at any moment is essential to relieve your everyday tasks and boost your efficiency. Achieve any goal with DocHub tools for document management and convenient PDF file editing. Gain access, adjust and save and incorporate your workflows with other safe cloud storage.
DocHub gives you lossless editing, the chance to use any format, and safely eSign papers without having searching for a third-party eSignature alternative. Maximum benefit of the file management solutions in one place. Consider all DocHub functions today with the free account.
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