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

mrxlsx

mrxlsx

Board Regular
Joined
Dec 15, 2012
Messages
95
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
 
Sort by date Sort by votes
mrxlsx said:
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
Click to expand...

Does...

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

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

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

mrxlsx
Click to expand...

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?
 
Upvote 0
mrxlsx said:
Aladin, Please check this below link now, sorry for the trouble.

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

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).
[TABLE="width: 757"]
<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>[TR]
[TD="class: xl66, width: 36, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 202, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 175, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 184, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 227, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 186, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Sno[/TD]
[TD="class: xl68, bgcolor: transparent"]Date[/TD]
[TD="class: xl68, bgcolor: transparent"]Recruiter[/TD]
[TD="class: xl68, bgcolor: transparent"]Technology[/TD]
[TD="class: xl68, bgcolor: transparent"]Location[/TD]
[TD="class: xl68, bgcolor: transparent"]Client[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 05, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]Java-Hibernate[/TD]
[TD="class: xl66, bgcolor: transparent"]Tulsa-OK[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 05, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bob, Beamon[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Minneapolis-MN[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 05, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bob, Beamon[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Miami-FL[/TD]
[TD="class: xl66, bgcolor: transparent"]Serengeti[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Tue, Aug 06, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Baxter, Teresa[/TD]
[TD="class: xl66, bgcolor: transparent"]Excel-VBA[/TD]
[TD="class: xl66, bgcolor: transparent"]Minneapolis-MN[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Wed, Aug 07, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bob, Beamon[/TD]
[TD="class: xl66, bgcolor: transparent"]Excel-VBA[/TD]
[TD="class: xl66, bgcolor: transparent"]Miami-FL[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Thu, Aug 08, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bob, Beamon[/TD]
[TD="class: xl66, bgcolor: transparent"]Excel-VBA[/TD]
[TD="class: xl66, bgcolor: transparent"]Miami-FL[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Fri, Aug 09, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]David, Hill[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Minneapolis-MN[/TD]
[TD="class: xl66, bgcolor: transparent"]HCL[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]David, Hill[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Lafayette-LA[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Lambert, Jody[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Essex-VT[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Lambert, Jody[/TD]
[TD="class: xl66, bgcolor: transparent"]C#[/TD]
[TD="class: xl66, bgcolor: transparent"]Lafayette-LA[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]11[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Mercado, David[/TD]
[TD="class: xl66, bgcolor: transparent"]C#[/TD]
[TD="class: xl66, bgcolor: transparent"]Lafayette-LA[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]12[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Lambert, Jody[/TD]
[TD="class: xl66, bgcolor: transparent"]C#[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Serengeti[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]C#[/TD]
[TD="class: xl66, bgcolor: transparent"]Minneapolis-MN[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]14[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]C#[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]15[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sat, Aug 10, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Southaven-MS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]16[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sun, Aug 11, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Larsen, Lara[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]17[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sun, Aug 11, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Larsen, Lara[/TD]
[TD="class: xl66, bgcolor: transparent"]ABAP[/TD]
[TD="class: xl66, bgcolor: transparent"]Minneapolis-MN[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]18[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Sun, Aug 11, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Larsen, Lara[/TD]
[TD="class: xl66, bgcolor: transparent"]ABAP[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Serengeti[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]19[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 12, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]ABAP[/TD]
[TD="class: xl66, bgcolor: transparent"]Southaven-MS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]20[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 12, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Young, Benjamin[/TD]
[TD="class: xl66, bgcolor: transparent"]ABAP[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]21[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 12, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]22[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 12, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Minneapolis-MN[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]23[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]Mon, Aug 12, 13[/TD]
[TD="class: xl66, bgcolor: transparent"]Bill, Carson[/TD]
[TD="class: xl66, bgcolor: transparent"]JDEdwards[/TD]
[TD="class: xl66, bgcolor: transparent"]Wichita-KS[/TD]
[TD="class: xl66, bgcolor: transparent"]Oldman Socks[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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.
 
Upvote 0
mrxlsx said:
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.
Click to expand...

hi,
just right click on the cell of that particular row then sort on the basis of newest to oldest.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Insert new columns, with headers - Macro/VBA help
Replies
5
Views
314
MARK858
MARK858
W
  • Question Question
Create a Dynamic Line Chart for last 4 weeks of data
Replies
2
Views
252
StephenCrump
S
V
  • Question Question
How can I update row data when the date column changes?
Replies
2
Views
67
VIETGATAN
V
C
  • Question Question
Populating different sheets based on the value in a column on another sheet.
Replies
3
Views
898
DanteAmor
DanteAmor
D
  • Question Question
Retrieve values from workbooks saved in another drive
Replies
8
Views
482
mumps
mumps

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top