Functions on filtered data

L

LiAD

Afternoon,

I have an excel sheet of 10 cols and 200 rows on sheet 1.
Sheet 2 has a table which searches through the list of data in sheet 1 to

1 - produce a list of unique items using the formula -
2 - find max/av/min of col F per item using formula -
3 - find max/av/min of col G per item using formula -
4 - count how many results per item there are using -

Indirect is used to drive the address so as the file only searches through
rows which contain data.

When i try and use the filters on sheet 1 to search specific items etc the
file is very long to update.

Is there a reason why it is so long to activate when i try to filter?
How can i speed this up?

Thanks
Lindsey
 
A

Ashish Mathur

Hi,

One reason could be that the file is linked to other Excel files. If that
is indeed the case, then paste special values the external links and see if
filtering happens fine
 

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

Top