PC Review


Reply
Thread Tools Rate Thread

can advanced filter in excel filters case sensitive records

 
 
priya
Guest
Posts: n/a
 
      20th May 2004
can advanced filter in excel filters case sensitive record

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      20th May 2004
In the criteria area, leave the heading cell blank
In the cell below, enter a formula that refers to the first row of data.
For example:

=EXACT(D2,"b")

priya < wrote:
> can advanced filter in excel filters case sensitive records



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
case sensitive filter =?Utf-8?B?Q3ludGhpYQ==?= Microsoft Access 5 8th Aug 2007 01:27 AM
Case sensitive filter =?Utf-8?B?U2h1ZGRlcjc3Nw==?= Microsoft Excel Worksheet Functions 3 25th Feb 2007 11:26 PM
can I filter by case in access filters? =?Utf-8?B?Z2JvZGll?= Microsoft Access 1 6th May 2005 11:03 PM
Case sensitive advanced filtering =?Utf-8?B?QmlnIFRvbnk=?= Microsoft Excel Misc 1 26th Jan 2005 08:22 PM
Advanced Filter Case Sensitive Joseph S Johnson Microsoft Excel New Users 4 24th May 2004 08:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:17 PM.