I have a column with quantities and a column with a number that can vary or be the same. I need a formula that will list the quantity of numbers. Below is a small example of what I have and what I want to see.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
This is what I have. This is what I need.<o></o>
Qty #’s Qty #’s<o></o>
4 20.501 6 30.875<o></o>
5 15.251 4 20.501<o></o>
2 30.875 1 19.625<o></o>
1 15.251 6 15.251 <o></o>
1 19.625 <o></o>
4 30.875 <o></o>
<o> </o>
I don't want to use any of the numbers in the formula, for that would take way too long to enter in.<o></o>
Any ideas would be greatly appreciated.<o></o>
<o> </o>
Thanks<o></o>
<o></o>
fficeffice" /><o></o><o
> </o>This is what I have. This is what I need.<o
></o>Qty #’s Qty #’s<o
></o>4 20.501 6 30.875<o
></o>5 15.251 4 20.501<o
></o>2 30.875 1 19.625<o
></o>1 15.251 6 15.251 <o
></o>1 19.625 <o
></o>4 30.875 <o
></o><o
> </o>I don't want to use any of the numbers in the formula, for that would take way too long to enter in.<o
></o>Any ideas would be greatly appreciated.<o
></o><o
> </o>Thanks<o
></o><o
></o>
