If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|