Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

error when using advanced filter,unique values

Posted by bruce taylor on June 01, 2001 12:22 AM

Using Data,Advanced filter,Unique Values only works properly except when the first value in the range being evaluated is repeated somewhere else in the range. That "unique" entry is displayed twice in the output. Is the a bug that I can work around ?
thanks

Re: error when using advanced filter,unique values

Posted by Edd on June 01, 2001 3:14 AM

It sounds like it is using the first cell in the range as a column header, and therefore not treating it as a value. You will need to insert a cell above the range and put in a column header. Then select the range as normal but include the inseretd column header then try.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.