FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
I am missing something here and not sure why or what. I'm trying to return the birthdays in March from earliest to latest.
Formula used
=IFERROR(INDEX($D$2:$D$31,AGGREGATE(15,6,(ROW($D$2:$D$31)-ROW($D$2)+1)/(MONTH($C$2:$C$31)=$F$1),ROWS($H$1:H1))),"")
And in F1 is the number 3. In the list below, 9 should be the first with 12 last
Cust Name | Cust Surname | Birthdate | Rank |
Ahmed | Mathews | 01-Jan | 1 |
Lieselotte | van Hees | 07-Jul | 22 |
Clemencia | van Bhiemond | 10-May | 16 |
Alissa | Leenards | 30-Apr | 14 |
Margo | Nuys | 04-Jun | 19 |
Kacey | Walters | 19-Apr | 13 |
Son | van Ijzendoorn | 15-Nov | 27 |
Jerrica | Brenk | 02-Jun | 18 |
Jada | Baerents | 05-Oct | 26 |
Blake | Calderon | 27-Sep | 25 |
Brett | Komen | 08-Jun | 20 |
Ernesto | Guthrie | 26-Mar | 12 |
Collin | Carpenter | 20-Jul | 23 |
Wilton | Hamilton | 16-Mar | 11 |
John | van Ede | 11-Jan | 3 |
Young | Kok | 09-Jan | 2 |
Corene | Santana | 10-Feb | 7 |
Kelvin | Fuller | 17-Jan | 4 |
Francine | Muir | 25-Dec | 30 |
Juan | Allen | 12-Jun | 21 |
Winnie | Ortiz | 05-Dec | 29 |
Sharyl | Fritz | 20-Jan | 6 |
Clement | Dean | 07-May | 15 |
Frankie | Diaz | 26-Feb | 8 |
Augustina | Simpson | 04-Dec | 28 |
Noelle | Reyes | 31-May | 17 |
Keith | Claes | 01-Mar | 9 |
Rudy | van Ojen | 05-Mar | 10 |
Grant | Buddingh | 18-Jan | 5 |
Marvella | Denhartog | 08-Aug | 24 |
Formula used
=IFERROR(INDEX($D$2:$D$31,AGGREGATE(15,6,(ROW($D$2:$D$31)-ROW($D$2)+1)/(MONTH($C$2:$C$31)=$F$1),ROWS($H$1:H1))),"")
And in F1 is the number 3. In the list below, 9 should be the first with 12 last