Good Morning!!!
I am attempting to make a table of contents on excel.
I have my discretion running through cell B,C,D,E.
I have the page numbers formatted as follows:
F = First Number
G = -
H = Second Number
Example:
BCDE= Different applications
F = 4
G = -
H = 5
I want a formula that states the next line's F = the pervious H +1 but some pages don't have an H value because they are only 1 page.
In that case I would like the next F = the previous F + 1.
Example:
BCDE = Table of Contents
F = 3
G = Blank
H = Blank
I also want to know how to make
G = -
only if there is a value in H
Thanks in advance TW.
I am attempting to make a table of contents on excel.
I have my discretion running through cell B,C,D,E.
I have the page numbers formatted as follows:
F = First Number
G = -
H = Second Number
Example:
BCDE= Different applications
F = 4
G = -
H = 5
I want a formula that states the next line's F = the pervious H +1 but some pages don't have an H value because they are only 1 page.
In that case I would like the next F = the previous F + 1.
Example:
BCDE = Table of Contents
F = 3
G = Blank
H = Blank
I also want to know how to make
G = -
only if there is a value in H
Thanks in advance TW.
