I have let's say one excel table (formatted as a table) in one sheet that has date column (in Column A) with some unique dates but starting from row ten (A10). Other rows are empty (because of the structure of table and the columns on the right).
What I wanted is to have that Date column on another sheet but in different cell, for instance C6 as starting point. And every time if I add something on the first sheet where unique dates are, I would like to have them auto populated on second sheet in defined column.
I tried on many ways but at the end I must do it manually, to drag it down to auto populate it... is there a way to do it automatically, to automatically expands every time one table is populated to get it on second?
What I used on to get the data on second sheet is:
=INDEX(Data['[Datum']];MATCH(0;COUNTIF($C$6:C6;Data['[Datum']]);0)) as an array formula.
Or if I direct reference:
=Sheet1! XYZ still can't be auto populated and must manually drag formulas down..
First thing is that number 00.01.1900 (on C7) which is wrong, can't get rid of it, and secondly table doesn't auto populate when I add something on Sheet 1.
