Beau the dog
Board Regular
- Joined
- Mar 8, 2021
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Good afternoon,
My work laptop has an old Mac version of excel - Version 16.16.27 (201012). there is no filter formula or unique formula etc...
So I have no idea how to achieve what I need...!
The shaded cell in the table below is at A1, this cell, I will change each week. I need a list of registrations from the first column, where the date in cell A1 appears in the any of the cells from B2:N16. The list can start in cell A18.
So with the current date selected in cell A1, the list would say:
BD12FAA
HK57OKL
...as these are the only registrations that have that date in the table. Seen in column 3, row 3 and 11. Thanking you in advance for any help.
My work laptop has an old Mac version of excel - Version 16.16.27 (201012). there is no filter formula or unique formula etc...
So I have no idea how to achieve what I need...!
The shaded cell in the table below is at A1, this cell, I will change each week. I need a list of registrations from the first column, where the date in cell A1 appears in the any of the cells from B2:N16. The list can start in cell A18.
So with the current date selected in cell A1, the list would say:
BD12FAA
HK57OKL
...as these are the only registrations that have that date in the table. Seen in column 3, row 3 and 11. Thanking you in advance for any help.