Hi all
I have a sheet containing dates, an associated name with a given date (let's pretend they are bookings for something - just to keep it simple) followed by three columns containing data associated with the booking.
What I would like to do is display the booking information starting in G2 (there will be a maximum of 6 bookings per date).
With tasks like this in the past, I have used a formula something along the lines of OFFSET(MATCH(TODAY(),A:A)...
However, I'm not sure how to work such a formula when the OFFSET parameters need change to reflect that there might only be one booking or there might be 6- so rows and col need to be changed dynamically.
Ideally, I would have blank spaces on the booking sheet, but unfortunately I don't have access to change how the booking sheet itself functions.
Any suggestions on how to dynamically change the offset parameters would be useful - though I'm fairly certain there may be a less complicated/better solution to this.
Thanks for your help!
I have a sheet containing dates, an associated name with a given date (let's pretend they are bookings for something - just to keep it simple) followed by three columns containing data associated with the booking.
What I would like to do is display the booking information starting in G2 (there will be a maximum of 6 bookings per date).
With tasks like this in the past, I have used a formula something along the lines of OFFSET(MATCH(TODAY(),A:A)...
However, I'm not sure how to work such a formula when the OFFSET parameters need change to reflect that there might only be one booking or there might be 6- so rows and col need to be changed dynamically.
Ideally, I would have blank spaces on the booking sheet, but unfortunately I don't have access to change how the booking sheet itself functions.
Any suggestions on how to dynamically change the offset parameters would be useful - though I'm fairly certain there may be a less complicated/better solution to this.
Thanks for your help!
Book4.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Date | Name | Data 1 | Data 2 | Data 3 | 23/10/2021 | |||
2 | 23/10/2021 | Dave | tea | blue | cat | ||||
3 | 23/10/2021 | Chris | tea | green | dog | ||||
4 | 23/10/2021 | Peter | coffee | orange | chicken | ||||
5 | 24/10/2021 | Rebecca | tea | red | cow | ||||
6 | 25/10/2021 | Lola | coffee | pink | dog | ||||
7 | 25/10/2021 | Dave | coffee | purple | penguin | ||||
8 | 25/10/2021 | Danielle | coffee | red | cat | ||||
9 | 25/10/2021 | Lucy | tea | red | cat | ||||
10 | 25/10/2021 | Olivia | tea | blue | dog | ||||
11 | 26/10/2021 | Dave | coffee | green | penguin | ||||
12 | 28/10/2021 | Peter | tea | blue | sheep | ||||
13 | 28/10/2021 | Olivia | coffee | blue | hamster | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G1 | G1 | =TODAY() |