Hi Vikas and Gurumurthy No , i cant use this formuals to get the desired results
On Apr 28, 4:28 am, gurumurthy sastry Kondury <gurumurthy.sas...@gmail.com> wrote: > 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 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- 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
