1

Topic: The formula display of the last line

Children hello! It was confused with one question, prompt as to make? It would be desirable to see in cell 2 the last line with contract date i.e. if to interpose a new line with new date that date it is displayed in cell 2. The example put

2

Re: The formula display of the last line

 = (A:A;  (A:A)) 

In the item Instead of should be passes

3

Re: The formula display of the last line

If in 2, instead of in other column,

 = (A3:A9999;  (A3:A9999)) 

4

Re: The formula display of the last line

Kazan, and  that shows date 00.01.1900, formats changed it is impossible

5

Re: The formula display of the last line

Kazan, all turned out made itself, excuse, thanks