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() |
