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
