How can I see a data's latest dates on top automatically daily?

[mrxlsx]

I have data relating to recruitment process. I want to see the latest dates on top everyday and as I work on it.
I have a difficulty of going down thousands of rows searching for today's data. I have daily 100 rows of updates. Is this possible by any Excel formulas without going for macros or VBA?

mrxlsx

 

[Aladin Akyurek]

Aladin,
As I said, I want to see the data with the latest dates on top, as simple as it. Data will not be changed in any way. I want just this. But, is there a way out for this in Excel. Everyday I have a problem going down for at least 100 rows for today's data and this is a recurring problem for me. Here is the data how I want to see.

https://hotfile.com/dl/238433478/ac84f8e/Sample.xlsx.html
Thank you.

I must be talking Russian. Can't you just say literally what outcome you want to see and where? You don't need to reference the file. I've already copied the relevant sample in my previous reply. Just try to answer the question based on that copy. To re-cap: Example...


a,10
b,20
c,17

I want to see the latest numerical value from A:C in X2, that is, X2 must house the outcome 17.

The foregoing illustrates what we mean by "the outcome you want to see", a "desired result", etc.