There is a table like this:

Table
How to make filtering by date so that when filtering all values ​​are displayed in the "Events" column for this date?

  • duplicate date in empty cells - teran
  • If you do not want to SEE the duplicated data - conditional formatting by the condition "= R [-1] C" to make the font white in white. - Akina

1 answer 1

Add. a column with dates in each row. For example, column C. Filter by this column. Formula:

=ЕСЛИ(A3>0;A3;C2)

'--------------------------

You can do without extra. column, quickly filling empty cells with missing values.

Select a range with dates (no table heading, only dates and empty cells).

After that, press Ctrl + G, Select-Empty-Cells-OK .

Without removing the selection, we write = (equals sign) and select the cell with the date in the top row. In fact, in the first selected empty cell, write the formula ( = A3 )

Last action - press Ctrl + Enter - all empty cells of the selected range will be filled with dates.