Select Products that Meet Profit Requirements Previous Topic

Previous Page 		Next Topic

Next Page

Do you want to quote only products in a certain price or profitability range? You can filter your price list to show only products that meet your requirements. Just type the column heading and criteria in two unused cells. Then click anywhere in the price list, click Advanced Filter (Data menu, Filter submenu), and specify the criteria range you just typed.

Screenshot shows part of a product list worksheet with a filtered column.

Tip Icon

 Do you have simple filtering criteria?   If you’re using uncomplicated criteria, you can use AutoFilter (Data menu, Filter submenu) to filter your list.

Office Assistant button Office Assistant button

Cross Reference Icon

 Want to know more?   Look up Getting Results - Customer Quote in Help.

Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>

©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.