Help with D functions

B

bmunge

I'm having a great deal of trouble figuring this problem out. I think
need to use a D function. I want to find the top ten values in
database, how do I go about doing that?

Edit: Also is there a way to edit the same cell position on multipl
sheets at the same time
 
P

Peter Atheron

The second part is yes

Select the sheets you wnat to edit by holding down the
shift key and clicking on the sheet tabs. Then any changes
made to the visible sheet are duplicated on the other
selected sheets.

Regards
peter
 
E

Earl Kiosterud

b,

It may be useful to sort the table in descending order on the column in
which you're interested in the top 10. That will list the entire top ten
records, based on that column.
 
A

AlfD

Hi!

Can you clarify one point: are all of these top 10 going to occur i
the same column of the database or could they be scattered around.

If they're in the same column and numeric, you could also us
Data>Filter>Autofilter which has an option called Top 10 (though it'
more than just that).

Al
 
Top