C
Chris
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.
--
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.
--