Formula for latest input

[Pasadu]

Please I want a formula whereby the latest typing or input made in A1-C1000 should be brought up in cell D1.
In other words, whenever I pick the data, I want a formula where I can determine the last input that was made, or the most current input made.
Thank you.

 

[GraH - Guido]

What's the input? Text, Number, Date?
What's your Excel version?

 

[Pasadu]

What's the input? Text, Number, Date?
What's your Excel version?

The input could be a text or number.
Excel version is Microsoft Office Professional Plus 2016

 

[bosco_yip]

Hi,

If you have Excel 2016 Professional version, you may have Textjoin fuction.

So

You can use this CSE (array) formula in D1, and enter like this :

=IFERROR(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,IF(TRANSPOSE(A1:C1000)<>"",TRANSPOSE(A1:C1000),""))&"</b></a>","//b[last()]"),"")

 

[bosco_yip]

Or, this

=IFERROR(IFERROR(LOOKUP(1,0/(C1:C1000<>""),C1:C1000),LOOKUP(1,0/(B1:B1000<>""),B1:B1000)),LOOKUP(1,0/(A1:A1000<>""),A1:A1000))

Regards