Find missing value in the cells

[ngc2392]

Hello guys, the title might be strange but I'll explain here. So, I have created formulas to show me name of the month in a cell across the sheet. If there is no data, the cell shows name of the month (november...), if data is there, it will remain blank. How can I see which months are missing in the range? Of course, the values should be displayed in 12 cells across the column (or 8 if 4 months are filled with data). I hope I made this question understandable?

 

[ngc2392]

ok, I managed this one with matching each cells (no formulas...). So, a simple check when there is a name of the month, this month should be edited.
Sorry, but sometimes if the solution is "stupid" and it works...then it's not stupid

 

[Peter Bartholomew]

Using 365, you could have a formula such as

= FILTER(months, NOT(data))

 

[ngc2392]

unfortunatelly, I do not own 365office. But, thanks anyway! Have a good day