Cass
09-25-2005, 01:45 AM
Hello!
I stopped autofiltering to use multicriteria or somthing like that.
1. filter1 criteria col. 2
2. filter1 is on and now i need filtering col.6 but there is 2-6 different criteria
3. when filter1 and filter2 is on sum all col.10 values
4. change filter2 criteria and sum again col.10 values
thinkin right to use array?
later change filter1 criteria and repeat step 2 - 4
I stopped autofiltering to use multicriteria or somthing like that.
1. filter1 criteria col. 2
2. filter1 is on and now i need filtering col.6 but there is 2-6 different criteria
3. when filter1 and filter2 is on sum all col.10 values
4. change filter2 criteria and sum again col.10 values
thinkin right to use array?
later change filter1 criteria and repeat step 2 - 4