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
|