filtering time

N

nader

Iam
using:=SUMPRODUCT(SUBTOTAL(3,OFFSET(N11:N10000,ROW(N11:N10000)-ROW(N11),0,1)),--(N11:N10000="160m"))formula
in 50 cells and subtotal function in 10 cells and I am working in a bout
10000R*30C cells.When I use auto filter I must wait a few time to calculate
and ready.I need speed calculate.
sorry for language problems.
thanks.
 
D

Don Guillett

One thing I did for a client was to break up the blocks into defined names
and applying formula to block instead of the 10000 rows.
 
N

nader

more explan please.

Don Guillett said:
One thing I did for a client was to break up the blocks into defined names
and applying formula to block instead of the 10000 rows.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
D

Don Guillett

If desired, you may send your workbook to my address below and I'll take a
look.
 

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

I need speed calculate when I filter rows. 5
Help with altering a formula 3
Formula causing run-time error in Excel Programming 2
Counting number of days excluding certain values 3
Formula causing run-time error 2
Auto filter formula - help needed 2
Extract uniques from filtered range 3
Formula to Count and Return Most common Value in a Dynamic Named Range 1

Top