AdvancedFilter Unique=True

[jknapp]

I'm having a problem with a very good macro in the VBA and Macros Excel 2007 book. For the macro on pages 272 and 273 I'm using the advanced filter. It is supposed to be filtering for unique names in a range. However, with certain names the reports that are generated are getting lumped together. An example would be reports for departments "Test" "Test2" and "Test3". Test2 and Test3 will generate unique reports. But Test will have all three of them together. I can rename all the departments, or I can figure out a way to have the "Unique:=True" choose only exactly what I want.

What criteria would I use, and how would I write that?

Thanks,
jknapp

 

[RoryA]

The Unique parameter is either True or False. No other options are possible. Your best bet is probably to add an additional grouping column that amalgamates the three 'Test' entries under a single group name.