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]

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

Does...

=LOOKUP(9.99999999999999E+307,B:B)

give you what you want?

 

[mrxlsx]

Hi Aladin, Where to enter this formula? I have Sno, Date, RecruiterName, Technology etc columns. Can you clarify me please? Thank you.

mrxlsx

 

[Aladin Akyurek]

Hi Aladin, Where to enter this formula? I have Sno, Date, RecruiterName, Technology etc columns. Can you clarify me please? Thank you.

mrxlsx

Care to post 5 rows of your data along with the outcome you want to see? And what is the current range including the headers you might have?

 

[mrxlsx]

Hi,

Please check this file, I have a range of 5000 rows for now. Thank you Aladin!

http://hotfile.com/dl/<wbr>238239290/03fd897/Sample.xlsx.<wbr>html

 

[Aladin Akyurek]

Hi,

Please check this file, I have a range of 5000 rows for now. Thank you Aladin!

http://hotfile.com/dl/<wbr>238239290/03fd897/Sample.xlsx.<wbr>html

File is not available.

 

[mrxlsx]

Aladin, Please check this below link now, sorry for the trouble.

https://hotfile.com/dl/238361294/e5ee8d5/Sample.xlsx.html

 

[Aladin Akyurek]

Aladin, Please check this below link now, sorry for the trouble.

https://hotfile.com/dl/238361294/e5ee8d5/Sample.xlsx.html

Ok, but there is nothing told about the outcome you want to see and where you want that outcome for the sample data the file contains (see also below).

Sno	Date	Recruiter	Technology	Location	Client
1	Mon, Aug 05, 13	Bill, Carson	Java-Hibernate	Tulsa-OK	Oldman Socks
2	Mon, Aug 05, 13	Bob, Beamon	JDEdwards	Minneapolis-MN	Oldman Socks
3	Mon, Aug 05, 13	Bob, Beamon	JDEdwards	Miami-FL	Serengeti
4	Tue, Aug 06, 13	Baxter, Teresa	Excel-VBA	Minneapolis-MN	Oldman Socks
5	Wed, Aug 07, 13	Bob, Beamon	Excel-VBA	Miami-FL	Oldman Socks
6	Thu, Aug 08, 13	Bob, Beamon	Excel-VBA	Miami-FL	Oldman Socks
7	Fri, Aug 09, 13	David, Hill	JDEdwards	Minneapolis-MN	HCL
8	Sat, Aug 10, 13	David, Hill	JDEdwards	Lafayette-LA	Oldman Socks
9	Sat, Aug 10, 13	Lambert, Jody	JDEdwards	Essex-VT	Oldman Socks
10	Sat, Aug 10, 13	Lambert, Jody	C#	Lafayette-LA	Oldman Socks
11	Sat, Aug 10, 13	Mercado, David	C#	Lafayette-LA	Oldman Socks
12	Sat, Aug 10, 13	Lambert, Jody	C#	Wichita-KS	Serengeti
13	Sat, Aug 10, 13	Bill, Carson	C#	Minneapolis-MN	Oldman Socks
14	Sat, Aug 10, 13	Bill, Carson	C#	Wichita-KS	Oldman Socks
15	Sat, Aug 10, 13	Bill, Carson	JDEdwards	Southaven-MS	Oldman Socks
16	Sun, Aug 11, 13	Larsen, Lara	JDEdwards	Wichita-KS	Oldman Socks
17	Sun, Aug 11, 13	Larsen, Lara	ABAP	Minneapolis-MN	Oldman Socks
18	Sun, Aug 11, 13	Larsen, Lara	ABAP	Wichita-KS	Serengeti
19	Mon, Aug 12, 13	Bill, Carson	ABAP	Southaven-MS	Oldman Socks
20	Mon, Aug 12, 13	Young, Benjamin	ABAP	Wichita-KS	Oldman Socks
21	Mon, Aug 12, 13	Bill, Carson	JDEdwards	Wichita-KS	Oldman Socks
22	Mon, Aug 12, 13	Bill, Carson	JDEdwards	Minneapolis-MN	Oldman Socks
23	Mon, Aug 12, 13	Bill, Carson	JDEdwards	Wichita-KS	Oldman Socks

<colgroup><col style="width: 27pt; mso-width-source: userset; mso-width-alt: 1280;" width="36"> <col style="width: 151pt; mso-width-source: userset; mso-width-alt: 7168;" width="202"> <col style="width: 131pt; mso-width-source: userset; mso-width-alt: 6229;" width="175"> <col style="width: 138pt; mso-width-source: userset; mso-width-alt: 6542;" width="184"> <col style="width: 170pt; mso-width-source: userset; mso-width-alt: 8078;" width="227"> <col style="width: 140pt; mso-width-source: userset; mso-width-alt: 6627;" width="186"> <tbody>
</tbody>

 

[mrxlsx]

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.

 

[prathamesh911]

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.

hi,
just right click on the cell of that particular row then sort on the basis of newest to oldest.