Microsoft’s Excel blog walks through a common but tricky scenario for Excel: pulling out all the rows from a large spreadsheet that match particular criteria. It’s detailed stuff, but much more useful than Microsoft’s built-in help on the same topic.
Build A Master Detail View In Excel
About the Author
Angus Kidman | Lifehacker Editor
Angus has been writing professionally about technology since 1994 and breaking it for even longer. He is based in Sydney but spends a frankly unhealthy portion of his life on the road, tracking down the latest stories. In 2011, he won the IT Journo Award For Best Consumer Technology Journalist and Consensus IT Writers Award for Best Technical Writer for his work on Lifehacker; about time too.