In Google Sheets, I have a table in which the headers should be all the unique start and end times that are in another table. However, when I use the Unique function, the result still contains duplicates. Does anyone know why this might be the case?
As you can see there are two 04:00 and two 05:00s in the result.
Here's the link to a dummy spreadsheet with the problem: Generic Sheet
Any help would be greatly appreciated.
Excel Formula:
=TRANSPOSE(SORT(FILTER(UNIQUE(FLATTEN(B3:B,E3:E)),UNIQUE(FLATTEN(B3:B,E3:E))<>""),1,1))
As you can see there are two 04:00 and two 05:00s in the result.
Here's the link to a dummy spreadsheet with the problem: Generic Sheet
Any help would be greatly appreciated.