-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
unique filter
-
A
Macro Help: Advanced Filter Unique Values to New Column
Greetings All, I am trying to create a macro that will take a list of names and using the advanced filter, copy the unique values to another location. The new list of unique names is being used to populate another area of the workbook. Seems easy, but for some reason, it will not work twice...- ACF0303
- Thread
- advanced filter advanced filtering macro unique filter
- Replies: 4
- Forum: Excel Questions
-
F
Extract Unique Value Based on Criteria
Hi Gurus, I need a help on getting my formula correct. I am trying to extract unique in a list, copy it to another sheet based on criteria. The formula im using is =INDEX(Data!$E$3:$E$232,MATCH(0,COUNTIF(Sheet2!$B$5,Data!$E$3:$E$232)+(Data!$C$3:$C$232<>Sheet2!$C$3),0), COLUMN(Data!E2)) I...- freqzz
- Thread
- criteria extract unique filter
- Replies: 3
- Forum: Excel Questions
-
L
Unique Filter Macro (Ignore Zeros)
Hi, My data is a column of zero's and dates. I have a basic unique filter macro to filter the dates. However, the first two results of the filter are two 'zero's. Could you please help me adjust the formula so that it ignores the zero's. Sub UniqueFilter()...- lewis1
- Thread
- advanced filter macro unique filter vba
- Replies: 6
- Forum: Excel Questions
