#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
Quote:
Thank you, Sunil Thoams |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
Quote:
Regards, Sunil Thomas |
Tags |
sorting date wise |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |