Hi, Just saw your query and the solution both. Doing this would be simple though.
> Then you have formed a separate drop down column in G2 putting the months as > reference - *How did you do this particular step??* This step is done through data validation. In Excel 2007 you can find this in Data tab on the ribbon. In 2003 version it can be found in Data menu. Select List in the Allow: drop down box and in the source you type in 1,2,3,4....12 click on OK and you will have a drop down box > *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. Correctly guessed it is conditional formatting in the main table. In the Select a rule type select "use a formula for cells to format" in the formula type =Month($D2)=$G$2 in the format section choose the font and fill type for the cell and you are done. In case you need further explanation feel free to reach me at anand...@gmail.com. Hope that helps, @Dave : Perfect solution. Neat and clean work, my appreciations for the solution Regards Anand Kumar On Nov 29, 8:58 pm, Anindya Roy <anind...@gmail.com> wrote: > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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&;... > > > -- > > > --------------------------------------------------------------------------- > > ------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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&;... -- ---------------------------------------------------------------------------------- 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
