Split total number of pages into ranges

[judi0802]

I am making a pagination plan for a book. I need to split total number of pages into ranges. What formula should i use? Hope to hear from you soon.

Example:
Column A is total number of page
Column B is book page number
Column C is actual page

Row 1:
Total number of page is 9
Book page number should be A1-A9
Actual page number should be 1-9

Row 2:
Total number of page is 2
Book page number should be A10-A11
Actual page number should be 10-11

etc...

[Sindhus]

Hi, Welcome to the forum

Can you share a dummy workbook with your expected output..?

[judi0802]

Please find attached

[Sindhus]

Is there any way to get rid of page numbers next to main sections? The count will be wrong, if both page numbers of main and sub sections got added.

[judi0802]

Not possible to get rid of total no. of pages column. I need a separate formula for book page no. and actual page no., but i dont know how to do it. What formula should i use?

[Sindhus]

For book page no.

Please Login or Register  to view this content.

For actual page no.

Please Login or Register  to view this content.

This will work, only if B19 and B27 are empty. Because, B19/B27 are split again into sub sections. So, it will double count the page nos.

[judi0802]

Will try this out. Thank you so much!

For book page no.

Please Login or Register  to view this content.

For actual page no.

Please Login or Register  to view this content.

This will work, only if B19 and B27 are empty. Because, B19/B27 are split again into sub sections. So, it will double count the page nos.