You're welcome! Thanks for letting me know how you fixed the problem.

Beau wrote:
Thanks Debra - Yes, the workbook was shared. I "un-shared" it and I was able
to use advanced filtering to fix my duplication problem.

"Debra Dalgleish" wrote:


Is the workbook shared? If it is, the Advanced Filter feature won't be
available. For more information on shared workbooks, look in Excel's
Help, under the topic 'Features that are unavailable in shared workbooks'

Beau wrote:

I'm trying to remove duplicate rows from an excel worksheet, but Advanced
Filtering is grayed out and not available. Is there a setting I need to
change to make this command available


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html