Figure Selecting unique values

12

Denver

13:

Denver

IT]

Denver

15

Denver

16

LgĀ£ Angeles_1

17 I

Lot Angeles

18 |

New Vork

19

New Vork

20

New York

~2l1

New York

"22]

New Vork

23

Portland

24

Portland

25

Seattle

26

Seattle

I have been asked many times by clients if Excel provides a way to make such selections. After a few such questions, I decided to write an Excel utility for this purpose. The dialog for this utility is shown in Figure 1-2. With this utility, the user can select a match type (such as number, date, or text) and a match criterion. If required, the user supplies one or two values for the match. This has proven to be an extremely useful utility.

0 0

Responses

Post a comment