of course is: =OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=11,ROW($B$2:$B$29)),ROW(A1))-1,) regards r
2010/11/29 roberto mensa <robb....@gmail.com> > =OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=3,ROW($B$2:$B$29)),ROW(A1))-1,) > > CTRL+SHIFT+ENTER > drag down > regards > r > > 2010/11/28 Anindya Roy <anind...@gmail.com> > > Suppose I have a file which contains names of the candidates along with >> their date of birth. Now if i want to sort out names which have birthday >> falling in the month of november. >> >> How do I do that. >> >> Please note that DOB is mm/dd/yyyy format. >> >> S.No >> Beneficiary Name >> Ward No >> DOB >> 1 >> Ambarish Ghosh >> 11 >> 12/8/1985 >> 2 >> Anirban Chakraborty >> 50 >> 7/13/1991 >> 3 >> Anasuya Das >> 21 >> 6/21/1981 >> 4 >> Ananya Dasgupta >> 37 >> 8/28/1984 >> 5 >> Asish Majhi >> 41 >> 2/11/1990 >> 6 >> Amit Kumar Sharma >> 27 >> 2/12/1984 >> 7 >> Abhijit Golui >> 37 >> 9/30/1989 >> 8 >> Bidisha Manik >> 12 >> 7/19/1985 >> 9 >> Baishakhi Mallick >> 9 >> 4/15/1986 >> 10 >> Biswajit Paul >> 10 >> 9/18/1984 >> 11 >> Barnali Roy >> 19 >> 11/11/1976 >> 12 >> Dipanjan Karar >> 18 >> 1/20/1988 >> 13 >> Jesmine Mondal >> 39 >> 12/18/1985 >> 14 >> Kabita Mukherjee >> 38 >> 8/24/1984 >> 15 >> Kabita Roy Bagchi >> 41 >> 8/12/1980 >> 16 >> Kalpana Dey >> 48 >> 5/6/1983 >> 17 >> Kartick Ghosh >> 48 >> 11/17/1988 >> 18 >> Kuntal Mukherjee >> 50 >> 5/5/1982 >> 19 >> Madhumita Das >> 39 >> 6/4/1985 >> 20 >> Madhumita Sardar >> 39 >> 5/3/1986 >> 21 >> Moumita Debnath >> 34 >> 12/23/1988 >> 22 >> Poly Mukherjee >> 45 >> 9/16/1988 >> 23 >> Papia Nath >> 49 >> 10/21/1979 >> 24 >> Rituparna Pal >> 22 >> 12/6/1983 >> 25 >> Rini Banerjee >> 33 >> 4/21/1988 >> 26 >> Shrabani Dey >> 40 >> 8/5/1975 >> 27 >> Subhajit Sheet >> 49 >> 3/10/1991 >> 28 >> Soma Ghosh >> 24 >> 12/19/1979 >> >> >> Thanks & Regards >> Anindya Roy >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts