Thank-you David, appreciated.

Bob

"David McRitchie" wrote in message
...
Hi Bob,
nice resolution / interpretation of what appears to be
really wanted by a means other than sorting. -- David

"Bob Phillips" wrote ...
You can do it without sorting.

On the summary page, for the Top 10, you can get the value like so
=LARGE(Sheet1!A:A,ROW(A1))
and just copy down 9 rows.

If you want some related data, use a formula like
INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0))

"Scott B. Hogle" wrote
One of the features on the presentation piece is a "Top
10 Client" listing - this is why I want automatic sorting.