Having comprehensive power over your documents at any time is vital to ease your everyday duties and enhance your efficiency. Accomplish any goal with DocHub features for document management and practical PDF file editing. Gain access, adjust and save and integrate your workflows along with other secure cloud storage services.
DocHub provides you with lossless editing, the chance to work with any formatting, and securely eSign documents without looking for a third-party eSignature alternative. Get the most from the file management solutions in one place. Consider all DocHub capabilities today with the free of charge account.
welcome to Excel magic trick number 308 hey if you want to download this workbook and follow along click on my youtube channel and click on my College website link and you can download the workbook magic trick 307 to 315 hey in this video we want to see how to extract some records from a different workbook with a formula Im going to switch over to this other workbook its just I have some data here control home brings me back to a 1 and I want to extract certain records based on certain criteria control tab is the keyboard shortcut to move between open Excel workbooks ctrl tab but there it is I want to start here and I want to do with the formula now Ive done lots of videos with about extracting records with formulas where we go do it all in the same workbook Ive also done it with advanced filter but this is going to be a formula thats looking into another excel workbook and extracting it first thing I need to do is count and I have a um theres I have another strange part of this