Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 349
- Office Version
- 365
- Platform
- Windows
Hi
Looking for formulas in cells A15 to B17 which give the first (Start) and last (End) row number of the months shown in column C.
Thanks
Looking for formulas in cells A15 to B17 which give the first (Start) and last (End) row number of the months shown in column C.
Thanks
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Text | ||||
2 | Text | ||||
3 | 01/10/21 | ||||
4 | 10/10/21 | ||||
5 | 17/10/21 | ||||
6 | 21/10/21 | ||||
7 | 01/11/21 | ||||
8 | 02/11/21 | ||||
9 | 17/11/21 | ||||
10 | 06/12/21 | ||||
11 | 21/12/21 | ||||
12 | 25/12/21 | ||||
13 | |||||
14 | Start | End | |||
15 | 3 | 6 | Oct | ||
16 | 7 | 9 | Nov | ||
17 | 10 | 12 | Dec | ||
Sheet1 |