Thread: Multiple row
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pushpendra
 
Posts: n/a
Default Multiple row



"Max" wrote:

I had presumed the duplicate numbering below
was a typo in your post:

+1.25 5 12
+1.50 5 12

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


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