How-To Geek on MSN

You need to know the difference between a range and an array in Excel

Understand the correct terminology to understand how Excel works in the background.

Excel’s Advanced Filter Features Made Easy : From Criteria Ranges to Copying Results

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.