Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old October 29th 04, 10:06 PM
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 29 Oct 2004 11:28:30 -0400, "Gauthier"
wrote:

Hi Ron...fyi - i finally came up w/ a solution that works...

I changed the heading in B1 to LEN

In the source data, I added another column with the heading LEN and the
formula as directed to determine your TRUE result. I adjusted the named
range data_range_for_filter to include the extra column.

I ran the code with these modifications and it worked!

Thanks for all your help and looking at my workbook for me!

Sandi


I just thought of another possibility. Since the regions are all numeric, why
not a column called REGION in the Criteria Range, with the criteria being
<100000000 ?


--ron

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
extracting numbers from string Chris Dowell via OfficeKB.com Excel Discussion (Misc queries) 1 January 12th 05 09:37 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 10:19 PM
Sorting imported "numbers" Confused on the tundra Excel Discussion (Misc queries) 5 December 17th 04 07:33 PM
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 2 December 6th 04 05:01 PM


All times are GMT +1. The time now is 02:02 AM.

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