darzu
New Member
- Joined
- Jul 13, 2020
- Messages
- 9
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- Mobile
- Web
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | OEM A | Page 1 | ||
2 | OEM A | |||
3 | OEM A | |||
4 | OEM A | |||
5 | OEM A | |||
6 | OEM B | Page 2 | ||
7 | OEM B | |||
8 | OEM B | |||
9 | OEM B | |||
10 | OEM B | |||
11 | OEM B | Page 3 | ||
12 | OEM B | |||
13 | OEM B | |||
14 | OEM B | |||
15 | OEM B | |||
16 | OEM B | Page 4 | ||
17 | OEM B | |||
18 | OEM B | |||
19 | OEM B | |||
20 | OEM B | |||
21 | OEM B | Page 5 | ||
22 | OEM B | |||
23 | OEM B | |||
24 | OEM B | |||
25 | OEM B | |||
26 | ||||
27 | ||||
28 | OEM A | Page 1 / Page 1 | ||
29 | OEM B | Page 2 / Page 5 | ||
Sheet8 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B28:B29 | B28 | ="Page "&MINIFS($B$1:$B$25,$A$1:$A$25,A28)&" / Page "&MAXIFS($B$1:$B$25,$A$1:$A$25,A28) |
OEM A | Page 1 |
OEM A | |
OEM A | |
OEM B | |
OEM B | |
OEM A | Page 1 - Page 1 |
OEM B | Page 1 - Page 1 |
Ok in understand, lets say i make an aditional column and complete on each row the page numbering it should work in this way?If print area is the only known factor for the start and end of each page then, to the best of my knowledge, what you are asking will not be possible with a formula.
OEM A | 1 |
OEM A | 1 |
OEM A | 1 |
OEM B | 1 |
OEM B | 1 |
OEM A | Page 1 - Page 1 |
OEM B | Page 1 - Page 1 |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | OEM A | 1 | ||
2 | OEM A | 1 | ||
3 | OEM A | 1 | ||
4 | OEM A | 1 | ||
5 | OEM A | 1 | ||
6 | OEM B | 2 | ||
7 | OEM B | 2 | ||
8 | OEM B | 2 | ||
9 | OEM B | 2 | ||
10 | OEM B | 2 | ||
11 | OEM B | 3 | ||
12 | OEM B | 3 | ||
13 | OEM B | 3 | ||
14 | OEM B | 3 | ||
15 | OEM B | 3 | ||
16 | OEM B | 4 | ||
17 | OEM B | 4 | ||
18 | OEM B | 4 | ||
19 | OEM B | 4 | ||
20 | OEM B | 4 | ||
21 | OEM B | 5 | ||
22 | OEM B | 5 | ||
23 | OEM B | 5 | ||
24 | OEM C | 5 | ||
25 | OEM C | 5 | ||
26 | ||||
27 | ||||
28 | OEM A | Page 1 - Page 1 | ||
29 | OEM B | Page 2 - Page 5 | ||
30 | OEM C | Page 5 - Page 5 | ||
Sheet8 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B28:B30 | B28 | ="Page "&INDEX($B$1:$B$25,MATCH(A28,$A$1:$A$25,0))&" - Page "&INDEX($B$1:$B$25,MATCH(A28,$A$1:$A$25,1)) |