Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple row
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 10 2 +0.50 10 3 +0.50 10 4 +0.50 10 5 +0.75 10 6 +0.75 10 7 +0.75 10 8 +0.75 10 9 +1.00 10 10 +1.25 10 11 +1.25 5 12 +1.50 5 12 +1.50 10 13 +1.50 2 14 Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) |