Functions on filtered data
 

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

Functions on filtered data
 

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"LiAD" wrote in message
...
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