Print Line Number in English Reading Story with No. of Paragraph

[sakijung]

Good afternoon, I want to give line number of reading subject for my students.
Paragraph-LineNo-para No-total lines-start no.
1-1-1-5-1
1-2-2-4-6
1-3-3-2-10
1-4-4-3-12
1-5-5-6-15
2-6-6-9-21
2-7-7-4-30
2-8-8-4-34
2-9-9-3-38
3-10-10-3-41
3-11-11-3-44

But now I just carry them by key the number in Paragraph and LineNo. I would like a link or formula that called for this example.
Best regards and Thank you.

 

[Gerald Higgins]

Hi, it's not at all clear what exactly you want.

Please can you describe very clearly what data you have, and what exactly you want to do with it.
What do you want the results to be ?

 

[sakijung]

Sorry. I have one reading passage. And then I want to give the line and the paragraph number.
1 1 Every Saturday Daniel and his family go to the beach.
2 They live far from the beach, but once a week the family
3 gets into the car and Daniel's father drives for hours until they arrive.

2 4 Daniel's parents love the beach. Daniel and his sister and brother love the beach.
5The family's dog loves the beach very much.

3 6 But it is a problem to go to the beach every week. Daniel's father gets tired from driving so many hours. The rest of the family gets tired
7 from sitting in the car for so many hours. Daniel's mother
8 says: "It's fun in the beach, but it takes too much time to get there and back!"

From the above example there are 3 paragraphs and 8 line. I am lazy to write number in front of them. So I copy, paste data and do a report in microsoft access.

I use excel to running number paragraphs and lines. I must read and count the whole story like paragraph one has 3 lines, paragraph two has 5 line ...... And then it easy for me to see and put the number into column by hand. I think if it has formula, it's very ok.
Paragraph number-----total lines
1--------------------------5
2--------------------------4
3--------------------------2
4--------------------------3
5--------------------------6
6--------------------------9
7--------------------------4
8--------------------------4
9--------------------------3
10------------------------3
11------------------------3
And I want the answers.
Paragraph--LineNo
1-----------1
1-----------2
1-----------3
1-----------4
1-----------5
2-----------6
2-----------7
2-----------8
2-----------9
3-----------10
3-----------11
The line no is start from 1,2,3.... to the last line of the whole story but paragraph numbers are duplicate upto the total lines in each paragraph like paragraph 1 has 3 lines so it must be 1,1 1,2 1,3. Please help again.