Hi All,
I have been puzzled by this for a few days and perhaps by looking
to hard for the answer I cant see it. If you could help it would be
appreciated.

Overview: I have 10 columns with Data in them, the first 9 contain numbers
or text and the tenth a $ figure, ( lets say its 10 rows deep this can
vary )and I have set the filter mode at the top.
what I would like to do is test every filter option over the 9 columns and
where the $ amount is greater record the setting then continue the test.

The options I wish to test are

= 2
not = 2
than
than and = 2
< than
< than and =2

so as an example it may look like

11:10:A:12:12:17:23:B:11 - $2.00
12:10:B:11:11:15:24:B:11 - $3.00
11:13:A:11:12:17:25:A:12 - $2.15

Similar down 10 rows

I can put a macro together to check the combos but for life of me can not
work out how to structure it, I get as far as step 1 and get muddled ( like
mentioned probably looked at it to long and overlooking the obvious )

I would start in Col 1 and filter the first number 11 get the total and
record it ( as the first entry ) then get the next number in Col 1 number 12
and filter that and if its better than before replace it and so on for col
1, but then get lost,

Do I dial up the first number in Col 2 ( 12 ) and re run the first part then
the second number in Col 2 ( 11 ) and run the first part again ?

then how do I bring the other columns into play ?

and that's just for the = 2 then I would need to start to combine the
options for example Col 1 ( = 2 ) Col 2 ( not = 2 ) Col 3 than and so on.

after the test I should get something like

C1: C2: C3: C4: C5: C6: C7: C8: C9: $
=11 10 =A ( AND SO ON ) $3.50

Giving me the best option based on the data trialed.
Appreciate any help, I can write the macro but need a pointer in the logics
of it all working to cover every possibility

Regards
Pete

your logic is wrong...

include all rows gives maximum $$.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"OZDOC1050" wrote:

Hi All,
I have been puzzled by this for a few days and perhaps by
looking
to hard for the answer I cant see it. If you could help it would be
appreciated.

Overview: I have 10 columns with Data in them, the first 9 contain
numbers or text and the tenth a $ figure, ( lets say its 10 rows deep
this can vary )and I have set the filter mode at the top.
what I would like to do is test every filter option over the 9 columns
and where the $ amount is greater record the setting then continue the
test.

The options I wish to test are

= 2
not = 2
than
than and = 2
< than
< than and =2

so as an example it may look like

11:10:A:12:12:17:23:B:11 - $2.00
12:10:B:11:11:15:24:B:11 - $3.00
11:13:A:11:12:17:25:A:12 - $2.15

Similar down 10 rows

I can put a macro together to check the combos but for life of me can
not work out how to structure it, I get as far as step 1 and get
muddled ( like mentioned probably looked at it to long and overlooking
the obvious )

I would start in Col 1 and filter the first number 11 get the total
and record it ( as the first entry ) then get the next number in Col 1
number 12 and filter that and if its better than before replace it and
so on for col 1, but then get lost,

Do I dial up the first number in Col 2 ( 12 ) and re run the first
part then the second number in Col 2 ( 11 ) and run the first part
again ?

then how do I bring the other columns into play ?

and that's just for the = 2 then I would need to start to combine the
options for example Col 1 ( = 2 ) Col 2 ( not = 2 ) Col 3 than and
so on.

after the test I should get something like

C1: C2: C3: C4: C5: C6: C7: C8: C9: $
=11 10 =A ( AND SO ON ) $3.50

Giving me the best option based on the data trialed.
Appreciate any help, I can write the macro but need a pointer in the
logics of it all working to cover every possibility

Regards
Pete