Hi,
I currently have this formula: =TEXTJOIN(",",,FILTER(TEXT(Daily_Data!$C$5:$C$5000,"dd/mm/yyyy"),Daily_Data!F5:F5000=LARGE(Daily_Data!F5:F5000,2)))&"."
Now this works fine, in that it will return the dates for the highest number in column F.
What I'm after is to have the value of "Header1" in cell A2 and then look up the table and return the dates of 11/04/2023,18/04/2023 and 05/05/2023. Then have the ability to copy the formula down, so in cell A3 the value of "Header2" would be in that cell and the result would be 13/04/2023,24/04/2023.
I currently have this formula: =TEXTJOIN(",",,FILTER(TEXT(Daily_Data!$C$5:$C$5000,"dd/mm/yyyy"),Daily_Data!F5:F5000=LARGE(Daily_Data!F5:F5000,2)))&"."
Now this works fine, in that it will return the dates for the highest number in column F.
What I'm after is to have the value of "Header1" in cell A2 and then look up the table and return the dates of 11/04/2023,18/04/2023 and 05/05/2023. Then have the ability to copy the formula down, so in cell A3 the value of "Header2" would be in that cell and the result would be 13/04/2023,24/04/2023.
| Row Labels | Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | Header8 | Grand Total |
| 11/04/2023 | 13 | 18 | 6 | 7 | 1 | 45 | |||
| 12/04/2023 | 7 | 2 | 14 | 5 | 3 | 2 | 33 | ||
| 13/04/2023 | 7 | 3 | 9 | 4 | 5 | 1 | 29 | ||
| 14/04/2023 | 2 | 5 | 2 | 8 | 17 | ||||
| 17/04/2023 | 7 | 1 | 17 | 4 | 6 | 3 | 38 | ||
| 18/04/2023 | 13 | 1 | 14 | 2 | 3 | 1 | 34 | ||
| 19/04/2023 | 4 | 1 | 16 | 8 | 3 | 32 | |||
| 20/04/2023 | 6 | 2 | 7 | 3 | 1 | 19 | |||
| 21/04/2023 | 10 | 1 | 10 | 3 | 4 | 28 | |||
| 24/04/2023 | 5 | 3 | 9 | 8 | 5 | 1 | 31 | ||
| 26/04/2023 | 4 | 15 | 2 | 7 | 1 | 2 | 31 | ||
| 27/04/2023 | 5 | 7 | 1 | 2 | 1 | 1 | 17 | ||
| 28/04/2023 | 7 | 11 | 1 | 6 | 1 | 26 | |||
| 1/05/2023 | 11 | 1 | 17 | 2 | 8 | 39 | |||
| 2/05/2023 | 9 | 15 | 1 | 5 | 30 | ||||
| 3/05/2023 | 5 | 14 | 2 | 3 | 24 | ||||
| 4/05/2023 | 7 | 1 | 12 | 7 | 3 | 1 | 31 | ||
| 5/05/2023 | 13 | 12 | 1 | 2 | 28 | ||||
| 8/05/2023 | 6 | 6 | 8 | 5 | 1 | 1 | 27 | ||
| 9/05/2023 | 4 | 14 | 1 | 3 | 22 | ||||
| 10/05/2023 | 12 | 1 | 4 | 3 | 8 | 28 | |||
| 11/05/2023 | 5 | 1 | 9 | 2 | 17 | ||||
| 12/05/2023 | 4 | 9 | 2 | 5 | 20 | ||||
| 15/05/2023 | 6 | 19 | 3 | 8 | 1 | 2 | 39 | ||
| 16/05/2023 | 6 | 12 | 2 | 2 | 1 | 1 | 24 | ||
| 17/05/2023 | 8 | 1 | 14 | 2 | 1 | 26 | |||
| 18/05/2023 | 12 | 15 | 4 | 12 | 43 | ||||
| 19/05/2023 | 11 | 7 | 8 | 12 | 5 | 43 |
