Hi Harmeet Singh, Thanks for your reply, It works for Month criteria, But i want it for Days criteria , for example if i have 3 entries fro 2nd Jan it shoudl consider as 1, for 3rd jan 2 entries then it should consider it as 1, So total 2 main entries for Jan.
Hope i am clear in explaning the problem On Apr 23, 7:59 am, Harmeet Singh <harmeet.hew...@gmail.com> wrote: > using formula. > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > > > > On Fri, Apr 23, 2010 at 5:04 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > > Hi Chetan, > > > It can be achieved through pivot table, check the attached file. > > > Let me know in case of any queries. > > > -- > > Thanks & Regards, > > > DILIP KUMAR PANDEY > > MBA-HR,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > > On Fri, Apr 23, 2010 at 12:03 PM, Chetan <chetu...@gmail.com> wrote: > > >> Hi all! > > >> I am stuck with the below problem > > >> Date Entry Employee > > >> 01/01/2010 Rightwing A > >> 01/01/2010 Left wing A > >> 01/01/2010 Rightwing B > >> 01/02/2010 Top B > >> 03/01/2010 Top C > > >> My final report looks like below, I need to have the count of unique > >> entries ( ex: if there are 2 entries in 1 single day, that will be > >> counted as 1 entry only) > > >> For febr > >> Employee Jan Feb March > >> A 1 > >> B 1 1 > >> C 1 > > >> How can i contsruct a formula to achieve this result? > > >> Regards, > >> Chetan > > >> -- > > >> ---------------------------------------------------------------------------------- > >> 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 > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> HELP US GROW !! > > >> We reach over 6,800 subscribers worldwide and receive many nice notes > >> about the learning and support from the group.Let friends and co-workers > >> know they can subscribe to group at > >>http://groups.google.com/group/excel-macros/subscribe > > > -- > > > ---------------------------------------------------------------------------------- > > 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 > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,800 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe > > a.xls > 28KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
