Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2018, 01:49 AM
suniltko suniltko is offline Formula For Sorting In Order Date Wise Windows 7 64bit Formula For Sorting In Order Date Wise Office 2010 64bit
Novice
Formula For Sorting In Order Date Wise
 
Join Date: Mar 2017
Location: Cochin, Kerala, India
Posts: 12
suniltko is on a distinguished road
Default Formula For Sorting In Order Date Wise

Hi All,

Please see attached excel file. While sorting dates as per the date of birth order, I'm getting a duplicate entry as indicated in attached snap since two peoples having same D.O.B. How I can fix this issue? Can you please advise.

Thank You,
Sunil Thomas
Attached Images
File Type: jpg Excel.JPG (191.9 KB, 18 views)
Attached Files
File Type: xlsx Test.xlsx (13.9 KB, 7 views)
Reply With Quote
  #2  
Old 05-15-2018, 03:45 AM
ArviLaanemets ArviLaanemets is offline Formula For Sorting In Order Date Wise Windows 8 Formula For Sorting In Order Date Wise Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

In attachment is how I would do it.

On sheet People is list of people with DOB. The column RowNo is needed for calculations and is meant to be hidden.

On sheet Birthdays, user enters a date from which the list of next birthdays is displayed, and sorts the birthdays table by Next BD.
Attached Files
File Type: xlsx Birthdays.xlsx (17.4 KB, 8 views)
Reply With Quote
  #3  
Old 05-15-2018, 03:58 AM
ArviLaanemets ArviLaanemets is offline Formula For Sorting In Order Date Wise Windows 8 Formula For Sorting In Order Date Wise Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Uploaded the workbook anew, as the formula for next birthday didn't calculate correctly for leap years (for BD on February 29). In new workbook the formula is corrected.
Attached Files
File Type: xlsx Birthdays.xlsx (17.5 KB, 8 views)
Reply With Quote
  #4  
Old 05-15-2018, 04:36 AM
suniltko suniltko is offline Formula For Sorting In Order Date Wise Windows 7 64bit Formula For Sorting In Order Date Wise Office 2010 64bit
Novice
Formula For Sorting In Order Date Wise
 
Join Date: Mar 2017
Location: Cochin, Kerala, India
Posts: 12
suniltko is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
Uploaded the workbook anew, as the formula for next birthday didn't calculate correctly for leap years (for BD on February 29). In new workbook the formula is corrected.
Thank you for your reply. But it seems the final details are NOT updating automatically as per today's date. I need upcoming birthdays at top as I've shown in my original excel. Can you please share your thoughts.

Thank you,
Sunil Thoams
Reply With Quote
  #5  
Old 05-15-2018, 06:06 AM
ArviLaanemets ArviLaanemets is offline Formula For Sorting In Order Date Wise Windows 8 Formula For Sorting In Order Date Wise Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

OK. Now the upcoming birthdays list is based on current date, and is ordered by birthday dates automatically. This means, that you have to keep some spare rows in upcoming birthdays table. When the table on sheet Birthdays is filled to last row, you have to add rows to table, to avoid some birthdays being left out.

In previous version, you had to sort the table.
Attached Files
File Type: xlsx Birthdays.xlsx (18.9 KB, 9 views)
Reply With Quote
  #6  
Old 05-15-2018, 09:18 PM
suniltko suniltko is offline Formula For Sorting In Order Date Wise Windows 7 64bit Formula For Sorting In Order Date Wise Office 2010 64bit
Novice
Formula For Sorting In Order Date Wise
 
Join Date: Mar 2017
Location: Cochin, Kerala, India
Posts: 12
suniltko is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
OK. Now the upcoming birthdays list is based on current date, and is ordered by birthday dates automatically. This means, that you have to keep some spare rows in upcoming birthdays table. When the table on sheet Birthdays is filled to last row, you have to add rows to table, to avoid some birthdays being left out.

In previous version, you had to sort the table.
Great...! Thank you. This is working fine. Thank you for your time and support.

Regards,
Sunil Thomas
Reply With Quote
Reply

Tags
sorting date wise

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula For Sorting In Order Date Wise How to change alphabetical order in Word for sorting in a foreign language BobK Word Tables 1 12-01-2017 05:17 PM
Auto-filter horizontally column wise on basis of date shoaib1989 Excel 0 02-18-2016 11:16 PM
Sorting in alphabetic order Dimsok Word VBA 5 09-10-2014 02:58 AM
How to fetch data from one sheet to another with complete details and date wise as well harisjawed86 Excel Programming 1 08-05-2014 09:10 PM
Formula to count entries as per month, year and submission wise from different sheets pinkacidpunk Excel 1 05-28-2013 08:26 AM

Other Forums: Access Forums

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


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