Help with D functions

  • Thread starter Thread starter bmunge
  • Start date Start date
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
 
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with fractions to decimal 1
Select dynamic data in 2 columns, and repeat macro to next sheet 2
Find and Replace variable string 11
editing question 5
How do I delete rows and multiple columns automatically? 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
calculate formula if cell value is positive, show 0 if negative 3
using the INDIRECT function 1

Back
Top