hi, if u went count of identify unique dates for employee ..
put.. =COUNTIF(A:A,A1) On Wed, Apr 28, 2010 at 12:34 AM, Chetan <[email protected]> wrote: > Can anyone help me on this issue > > On Apr 26, 5:13 am, Chetan <[email protected]> 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 <[email protected]> wrote: > > > > > > > > > > > > > using formula. > > > > > Thanks & Regards, > > > > > Harmeet Singh > > > > > Sent via BlackBerry Wireless > > > > > On Fri, Apr 23, 2010 at 5:04 PM, Dilip Pandey <[email protected]> > 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 > > > > [email protected] > > > > [email protected] > > > > New Delhi - 62, India > > > > > > On Fri, Apr 23, 2010 at 12:03 PM,Chetan<[email protected]> 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 [email protected] > > > > > >> <><><><><><><><><><><><><><><><><><><><><><> > > > >> 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 [email protected] > > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > 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 [email protected] > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > 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 [email protected] > > > > <><><><><><><><><><><><><><><><><><><><><><> > > 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > 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 > -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- [email protected],[email protected], 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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
