software

I have a data like following

Power Qty
0.25 20
0.50 30
0.75 40
1.00 10
1.25 15
1.50 17

I want to insert data for each power not exceeding the total quantity of 10
and for each group of 10 quantities; I want to give a number like 1,2,3,4
etc.

Like This:

Power Qty Number
0.25 10 1
0.25 102
0.50 103
0.50 104
0.50 105
0.75 106
0.75 107
0.75 108
0.75 109
1.00 1010
1.25 1011
1.25 512
1.50 512
1.50 1013
1.50 2 14

Please help.
Not very sure, but maybe you want something like this:

Assume this is in cols A and B, data from row2 down

gt; Power Qty
gt; 0.25 20
gt; 0.50 30
gt; 0.75 40
etc

Put in C2: =IF(D2=quot;quot;,quot;quot;,COUNTIF($D$22,quot;xquot;))
Put in D2: =IF(B2=quot;quot;,quot;quot;,IF(B2lt;=10,quot;xquot;,quot;quot;))
Select C22, copy down as far as required

Col C will return the required sequential numbering

Is the above what you're after ?
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Pushpendraquot; gt; wrote in message
...
gt; I have a data like following
gt;
gt; Power Qty
gt; 0.25 20
gt; 0.50 30
gt; 0.75 40
gt; 1.00 10
gt; 1.25 15
gt; 1.50 17
gt;
gt; I want to insert data for each power not exceeding the total quantity of
10
gt; and for each group of 10 quantities; I want to give a number like 1,2,3,4
gt; etc.
gt;
gt; Like This:
gt;
gt; Power Qty Number
gt; 0.25 10 1
gt; 0.25 10 2
gt; 0.50 10 3
gt; 0.50 10 4
gt; 0.50 10 5
gt; 0.75 10 6
gt; 0.75 10 7
gt; 0.75 10 8
gt; 0.75 10 9
gt; 1.00 10 10
gt; 1.25 10 11
gt; 1.25 5 12
gt; 1.50 5 12
gt; 1.50 10 13
gt; 1.50 2 14
gt;
gt; Please help.
gt;
gt;
I had presumed the duplicate numbering below
was a typo in your post:

gt; 1.25 5 12
gt; 1.50 5 12
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--


quot;Maxquot; wrote:

gt; I had presumed the duplicate numbering below
gt; was a typo in your post:
gt;
gt; gt; 1.25 5 12
gt; gt; 1.50 5 12
gt; --
gt; Rgds
gt; Max
gt; xl 97
gt; ---
gt; Singapore, GMT 8
gt; xdemechanik
gt; savefile.com/projects/236895
gt; --

No, it doesn't work.

I actually want to insert multiple row from a single row automatically
against a given row with a criterial not greater than 15 or any number and
after every group of 15; I want to assign a number like 1,2,3 automatically.

For eg:
Power Qty Power Qty No
0.25 35 0.25 10 1
0.50 12 0.25 10 2
0.25 10 3
0.25 5 4
0.50 5 4
0.50 7 5
And so on.

help me
gt; No, it doesn't work...

Thanks for feedback. Guess the suggestion wasn't what you wanted. I'm out of
ideas here. Hang around awhile for possible views from others. Good luck !
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--