Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Sum of filtered data | Excel Worksheet Functions | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions |