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

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

Hi - 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!


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 ?


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

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

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

About Us

"It's about Microsoft Excel"


Copyright © 2017