Info

Change the List Range to a Single Column

Edit the List range to point to the Customer column. In this case it means changing the default $A$1:$H$1127 to $D$1:$D$1127. The Advanced Filter dialog should appear, as shown in Figure 11.2.

Figure 11.2

These settings copy a unique list of customers from Column D to Column J.

Figure 11.2

These settings copy a unique list of customers from Column D to Column J.

The drawback of this method is that Excel remembers the list range on subsequent uses of the Advanced Filter command. If you later want to get a unique list of regions, you will be constantly respecifying the list range.

Change the List Range to a Single Column

With a little forethought before invoking the Advanced Filter command, you can allow Excel to keep the default list range of $A$1:$H$1127. In cell J1, type the Customer heading. In Figure 11.3, you leave the List Range field pointing to Columns A through H. Because the Copy To range of J1 already contains a valid heading from the list range, Excel copies data only from the Customer column. I prefer this method, particularly if you will be doing multiple advanced filters. Because Excel remembers the prior settings from the last Advanced Filter, it is more convenient to always filter the entire columns of the list range and limit the columns by setting up headings in the Copy To range.

0 0

Post a comment