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 |
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. |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com