Info

Figure 11.3

By setting up a heading in the Copy To range of J1,you can avoid having to re-specify the list range for each Advanced Filter.

Figure 11.3

By setting up a heading in the Copy To range of J1,you can avoid having to re-specify the list range for each Advanced Filter.

After using either of these methods to perform the Advanced Filter, a concise list of the unique customers appears in Column J (see Figure 11.4).

0 0

Post a comment