Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 03-15-2022, 02:08 AM
ArviLaanemets ArviLaanemets is offline Date Sorting Problem Windows 8 Date Sorting Problem Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by PomDave View Post
Yes, I thought I was pushing the bounds of possibilities, still it was worth a try as I know that there are some really smart bunnies out there.
A simplest solution - replace all non-date numeric entries (year numbers) manually with dates. E.g. instead 1965 enter a date like 01.01.1965, and instead 1985 enter 01.01.1985.
In case you want to display them as year numbers, simply format those cells as custom "yyyy" (but this is not obligatory). Now sorting by date returns exactly what you want.

In case those data are read dynamically form some database, the solution can be more tricky, involving a helper column where all non-date entries are replaced with calculated dates, and date entries with copy of dates, using some complex formula. Then you can sort by this helper column.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Sorting Problem Formula For Sorting In Order Date Wise suniltko Excel 5 05-15-2018 09:18 PM
Sorting Problem RonLEngle Excel Programming 8 12-19-2017 01:15 PM
Sorting problem in Excel nrsmd Excel 2 10-08-2017 11:54 AM
Date Sorting Problem Problem sorting names alphabetically? mikehende Excel 12 09-12-2012 12:00 PM
sorting problem gsrikanth Excel 4 02-16-2012 12:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft