$$Excel-Macros$$ Find the last 5 users

2010-05-07 Thread Chetan
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 :

Re: $$Excel-Macros$$ Identify unique dates for employee

2010-04-29 Thread Chetan
Hi Vikas and Gurumurthy No , i cant use this formuals to get the desired results On Apr 28, 4:28 am, gurumurthy sastry Kondury 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 >

Re: $$Excel-Macros$$ Identify unique dates for employee

2010-04-28 Thread Chetan
Can anyone help me on this issue On Apr 26, 5:13 am, Chetan 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

Re: $$Excel-Macros$$ Identify unique dates for employee

2010-04-26 Thread Chetan
problem On Apr 23, 7:59 am, Harmeet Singh wrote: > using formula. > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > > > > On Fri, Apr 23, 2010 at 5:04 PM, Dilip Pandey wrote: > > Hi Chetan, > > > It can be achiev

$$Excel-Macros$$ Identify unique dates for employee

2010-04-23 Thread Chetan
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