Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 11th 12, 09:46 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 5
Default Excel 2007 custom filter



"Randy Tingley" wrote in message
t...



"Ron Rosenfeld" wrote in message
...

On Tue, 10 Apr 2012 19:36:35 -0400, "Randy Tingley"
wrote:

Good evening,
I am having an issue in displaying in the Excel Filter all records that
have
".." double period in the starting of the text.
The text in columns looks like:

column B

.xxxxxxx
..xxxxxx
…xxxxxx
.xxxxxxx
..xxxxxxx
…xxxxxxx
…xxxxxxx

and is approx 2000 rows.
The outcome should only show the ..xxxxxxxxx records.

Any ideas? Any assistance will be greatly appreciated.
Randy



One way would be to use the Advanced Filter

B1: Label
B2: First Record
B3: Second Record
etc.


Criteria Range (example)
H1:I2

H1:I1 leave these cells blank
H2: =LEFT(B2,2) = ".."
I2: =MID(B2,3,1)<"."

If you leave the cursor in column B, the wizard will likely select the
entire column.

Data / Advanced Filter

Action: Select either option as appropriate. Until debugged, I would
suggest "Copy to another Location"

List Range: $B$1:$B$2000 (or whatever range encompasses your data)
Criteria Range: $H$1:$I$2
Copy to: Wherever

<OK

Thank you!
I will try this!
Randy


Worked like a Champ!
Thank you!
Randy


  #2   Report Post  
Old April 11th 12, 10:00 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default Excel 2007 custom filter

On Wed, 11 Apr 2012 16:46:04 -0400, "Randy Tingley" wrote:

Thank you!
I will try this!
Randy


Worked like a Champ!
Thank you!
Randy


Glad to help.
Thanks for the feedback.


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
Custom filter limit removed in 2007? Anthony Excel Discussion (Misc queries) 1 April 8th 11 02:09 PM
Excel 2007: Custom Filter lex Excel Worksheet Functions 1 September 8th 09 03:28 PM
DataFilterAuto Filter in excel 2007? TIJ New Users to Excel 2 November 13th 08 04:28 AM
Excel 2007 Auto Filter Filter Django Excel Discussion (Misc queries) 2 September 9th 08 10:52 PM
Need help w using custom image for custom toolbar in Excel 2007 vbaexperimenter Excel Programming 10 June 23rd 08 06:05 PM


All times are GMT +1. The time now is 04:59 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017