Excel 2007 custom filter

[Randy Tingley]

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







***********************************************************************

Randy Tingley "Life is an
Adventure,

Mary Tingley not
an ulcer giving experience"

(e-mail address removed)

***********************************************************************

 

[Ron Rosenfeld]

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>

 

[Randy Tingley]

"Ron Rosenfeld" wrote in message

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

 

[Randy Tingley]

"Randy Tingley" wrote in message



"Ron Rosenfeld" wrote in message

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

 

[Ron Rosenfeld]

Thank you!
I will try this!
Randy


Worked like a Champ!
Thank you!
Randy

Glad to help.
Thanks for the feedback.