VBA Problems
 

I have 4 charts like the following
Product Count Age
120 4
2 5
1 6
58 7
14 8
3 11
73 12
44 13
1 14
38 15
55 18
4 19
5 20
4 21
6 22
5 25
4 26
1 28

I would like to be able to take the product count that is the oldest that
has at least 5 products in it and put it into another worksheet. I am a
novice to say the least at excel and some of its functions. I have tried
with vlookup but just cant seem to get it. If anyone could give me a hand I
would be eternally grateful. Thank you in advance.

--

VBA Problems
 

Chris,

Have you tried Pivot Charts..

they have sorting and Top X capabilities builtin.


keepITcool

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


"Chris" wrote:

I have 4 charts like the following
Product Count Age
120 4
2 5
1 6
58 7
14 8
3 11
73 12
44 13
1 14
38 15
55 18
4 19
5 20
4 21
6 22
5 25
4 26
1 28

I would like to be able to take the product count that is the oldest
that has at least 5 products in it and put it into another worksheet.
I am a novice to say the least at excel and some of its functions. I
have tried with vlookup but just cant seem to get it. If anyone could
give me a hand I would be eternally grateful. Thank you in advance.