Friday, July 8, 2011

How to Filter Price Guide by Console

Many price guide subscribers are only interested in seeing prices for certain consoles. Maybe they only sell newer consoles like Xbox 360, PS3, and Wii. This guide below shows you how to display only the consoles you want using Excel.

Download the Price Guide

Download the price guide and save it to your computer. (If you're not a subscriber you can start a free account)

Select Data to Filter

Click on cell "A1". Then go to the "Data" menu and choose Filter > AutoFilter.
Excel Auto Filter

This will select all the data and insert drop-down menus at the top of every column.
Excel Auto Filter Enabled

Choose The Console You Want To See

Click on the drop-down menu in the "Console Name" column. This will bring up a list of all the consoles in the price guide. Choose the console you want to see and Excel will only show items matching that console.

This article is a part of a series of posts with how to articles for our price guide subscribers.

0 comments :

Post a Comment

ShareThis

 

Login | Create Account