DarkoDeign2
Board Regular
- Joined
- Jun 20, 2023
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
I have dates in col B.
In col E I would like to have a formula to indicate the first row of the same dates, as shown in the example below. How can I do this in the easiest way?
In col E I would like to have a formula to indicate the first row of the same dates, as shown in the example below. How can I do this in the easiest way?
Book2 | ||||||
---|---|---|---|---|---|---|
B | E | |||||
2 | Date | Status | ||||
3 | 2023-07-26 | First | ||||
4 | 2023-07-26 | |||||
5 | 2023-07-26 | |||||
6 | 2023-07-26 | |||||
7 | ||||||
8 | 2023-08-02 | First | ||||
9 | 2023-08-02 | |||||
10 | 2023-08-02 | |||||
11 | ||||||
12 | 2023-08-10 | First | ||||
13 | 2023-08-10 | |||||
14 | 2023-08-10 | |||||
15 | 2023-08-10 | |||||
16 | 2023-08-10 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3:B7,B11 | B3 | =IFERROR(IF('[Agenda & Minutes (2).xlsx]Agenda'!B3="","",'[Agenda & Minutes (2).xlsx]Agenda'!B3),"Error") |