Can anyone help me on this issue On Apr 26, 5:13 am, Chetan <chetu...@gmail.com> wrote: > 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: > > > HiChetan, > > > > 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 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- 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
