New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one condition (criteria criterion) and list them in order with no extra rows between records. You may also use the INDIRECT function to save on formula creation time.
Home
Microsoft Office How to Extract part of a table from a larger table in Excel
![](https://assets.content.technologyadvice.com/thumbnail_Logos_Wonder_How_To_color_light_21e00e7b4a.webp)
By getexcellent
Apr 14, 2010 07:39 PM
![Excel spreadsheet displaying department records with data columns for employees, purpose, and cost.](https://assets.content.technologyadvice.com/634756294051703040_14dd994736.webp)
Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.
Comments
Be the first, drop a comment!