$$Excel-Macros$$ Find the last 5 users
Someone has changed data in my sheet and i want to know the last 5 users , is there any possiblity to track the users -- -- 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
Re: $$Excel-Macros$$ Identify unique dates for employee
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(F20,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,Chetanchetu...@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
Re: $$Excel-Macros$$ Identify unique dates for employee
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,Chetanchetu...@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
Re: $$Excel-Macros$$ Identify unique dates for employee
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