Re: $$Excel-Macros$$ Stumped with count if's

2009-12-05 Thread Dilip Pandey
Dear Zilla, Attached file would be help you to get the logics of IFs. Let me know if it solves your query. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/1/09, Zilla wrote: > > I am stum

Re: $$Excel-Macros$$ Declare weekends

2009-12-05 Thread Dilip Pandey
Dear Nikhil, Try using NETWORKDAYS formula to calculate difference between dates, it will speak weekend holidays. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/2/09, nikhil deshpande wr

Re: $$Excel-Macros$$ Where to Learn Excel

2009-12-05 Thread Dilip Pandey
Dear Abdul, There are many online tutorials are available over Internet, not sure if you are asking about a video tutorial. Try the below website, it has tutorials with pictures. www.brainbell.com Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@g

Re: $$Excel-Macros$$ ||URGENT|| Need help is filtering/extracting names and counting values

2009-12-05 Thread Dilip Pandey
Dear Abhishek, In order to learn Pivot Tables, you can try below link:- http://www.cpearson.com/excel/pivots.htm Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/4/09, Abhishek Jain wrote:

Re: $$Excel-Macros$$ Help on Date Function

2009-12-05 Thread Dilip Pandey
Hi Gopi, The attached workbook has been revised as per your requirements. Now whenever the current user will close the workbook, the date stamp will freeze automatically. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.c