#1   Report Post  
Chris
 
Posts: n/a
Default Advanced Filter

Using Office 2000...

Trying to use an advanced filter to filter only the unique records... The
option is always grayed out... why?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default 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?



  #3   Report Post  
Giulia
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
advanced filter a range Il Principe Excel Worksheet Functions 2 August 1st 05 03:27 PM
Using advanced filter to search for criteria in a list Potatosalad2 Excel Discussion (Misc queries) 1 June 8th 05 03:08 AM
Advanced filter question Heinzpickle Excel Discussion (Misc queries) 3 March 25th 05 04:49 PM
Advanced Filter: No Filter Evan Weiner - Richalnd WA Excel Discussion (Misc queries) 2 December 9th 04 04:36 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"