Having complete power over your documents at any moment is important to ease your everyday duties and enhance your productivity. Accomplish any goal with DocHub features for document management and convenient PDF editing. Access, adjust and save and incorporate your workflows along with other safe cloud storage services.
DocHub provides you with lossless editing, the opportunity to use any format, and securely eSign papers without having looking for a third-party eSignature option. Make the most of your document management solutions in one place. Consider all DocHub features 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