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 |
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 |