=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