Thanks a million Dave. You have just served it on a platter for me. Simply awesome.
But would request you to explain the steps if possible as I am a begginer in excel. What I could decipher is that You have formed a separate column and have put the formula. Then you have formed a separate drop down column in G2 putting the months as reference - *How did you do this particular step??* *It also seems that you have done conditional formatting in the main table. But how is that only the month which am sorting is showing red in colour??You need to explain me this step too. * *Regards* *Anindya * On Mon, Nov 29, 2010 at 2:44 PM, Dave Bonallack <davebonall...@hotmail.com>wrote: > Hi, > Not quite sure what you mean by "sort out names" but have a look at the > attached. You can select the month you want by using the drop-down in cell > G2 (1 to 12) > The main table contains Conditional Formatting, while Col E contains > formulas. > Regards - Dave. > > ------------------------------ > Date: Sun, 28 Nov 2010 23:15:14 +0530 > Subject: $$Excel-Macros$$ > From: anind...@gmail.com > To: excel-macros@googlegroups.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 > -- ---------------------------------------------------------------------------------- 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
