LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Use criteria in an Advanced Autofilter's single column

I have an Adv Autofilter that has 9 different columns as criteria. I want to
use 1 column to do an " Or" statement, e.g Salaried Or Hourly, the other
columns may have "or" statements as well. I cannot figure out how the string
must look for the autofilter to recognize it. Thus when I put in Salaried or
Hourly it returns nothing. Is there a way that can be done? Any help is
very much appreciated.
 
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
change XL2003 autofilter's arrow color BK Excel Discussion (Misc queries) 9 February 5th 10 11:42 AM
Sumproduct, single criteria identified within multiple in single c Monte Excel Discussion (Misc queries) 4 July 18th 09 11:21 PM
sumproduct with multiple criteria in single column my Excel Discussion (Misc queries) 4 July 5th 07 07:57 PM
How do I find blank cells using AutoFilter's Custom feature? Andrea Blake Excel Worksheet Functions 2 November 30th 04 09:03 PM
autofilter's events Mark[_17_] Excel Programming 3 September 11th 03 01:13 PM


All times are GMT +1. The time now is 11:01 AM.

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

About Us

"It's about Microsoft Excel"