Hi Chetan, May be you can Use If condition like below :
=IF(F2>0,1,0) - If the entry is in cell F2. Cuz you put any value more than 1, it will give you only 1 as required. Hope this works. Best Regards, Haigreeva. On 4/28/10, Chetan <chetu...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
