ExcelBanter - Advanced Filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Advanced Filter (https://www.excelbanter.com/excel-discussion-misc-queries/54740-advanced-filter.html)

Chris

Advanced Filter

Using Office 2000...

Trying to use an advanced filter to filter only the unique records... The
option is always grayed out... why?

Bob Phillips

Advanced Filter

Perhaps you are using a shared workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
Using Office 2000...

Trying to use an advanced filter to filter only the unique records... The
option is always grayed out... why?

Giulia

Advanced Filter

I have come across this when using a shared workbook.
If this is the case with you making the workbook exclusive should make the
advanced filter available.

"Chris" wrote:

Using Office 2000...

Trying to use an advanced filter to filter only the unique records... The
option is always grayed out... why?

All times are GMT +1. The time now is 04:02 AM.