Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table loaded from excel looks like that
Nr. Count. Sum.
1 1 10
2 1 10
3 1 10
4 2 20
6 1 10
7 4 40
11 1 10
I need add line(s) after line where count > 1. Add count - 1 lines with Nr. = Nr.+ 1. and sum = sum/count. To get in final somthing like that:
Nr. Count. Sum.
1 1 10
2 1 10
3 1 10
4 1 10
5 1 10
6 1 10
7 1 10
8 1 10
9 1 10
10 1 10
11 1 10
Look at " LOAD ... WHILE" syntax, in conjunction with function "IterNo()" - those two will help you solve the problem.
Oleg
Look at " LOAD ... WHILE" syntax, in conjunction with function "IterNo()" - those two will help you solve the problem.
Oleg
Thank, Oleg.