Hello
Need help on creating formula for contents.
In column A is reference page follow by column B pages a list of fruits and then create excel formula in column C to print first and last range of page numbers by each different type of fruits. see example below
For example there are 2 pages about apple, look at first and last pages of apple, range is 1-2
Thank you
Jake
Does anyone know how to
Need help on creating formula for contents.
In column A is reference page follow by column B pages a list of fruits and then create excel formula in column C to print first and last range of page numbers by each different type of fruits. see example below
For example there are 2 pages about apple, look at first and last pages of apple, range is 1-2
Thank you
Jake
Ref page | list of fruit | range of page number |
1 | apple | 1-2 |
1 | apple | 1-2 |
1 | apple | 1-2 |
2 | apple | 1-2 |
2 | apple | 1-2 |
2 | apple | 1-2 |
3 | banana | 3-7 |
3 | banana | 3-7 |
3 | banana | 3-7 |
3 | banana | 3-7 |
3 | banana | 3-7 |
3 | banana | 3-7 |
3 | banana | 3-7 |
4 | banana | 3-7 |
4 | banana | 3-7 |
4 | banana | 3-7 |
5 | banana | 3-7 |
6 | banana | 3-7 |
7 | banana | 3-7 |
8 | pear | 8 |
8 | pear | 8 |
9 | grapes | 9-13 |
10 | grapes | 9-13 |
11 | grapes | 9-13 |
11 | grapes | 9-13 |
12 | grapes | 9-13 |
13 | grapes | 9-13 |