O
OZDOC1050
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 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
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
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