$$Excel-Macros$$ Solution required

2011-10-14 Thread N Pradhan
Dear Experts, I have been given the following task. Please help me solving the problem attached in the excel sheet. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l

Re: $$Excel-Macros$$ Ebooks for Pivot Table and Chart

2011-09-29 Thread N Pradhan
Dear Noorain Sir, I am having some problem in the attached pivot. I want a calculated field (count of name - count of absent) which is non-numeric Please solve. Thanks N Pradhan - Original Message - From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday

$$Excel-Macros$$ How to Copy a Cell Comment

2011-08-19 Thread N Pradhan
Hi, How do you copy Cell Comments, Please help. Regards. -- -- 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 @

Re: $$Excel-Macros$$ Extract only mother names

2011-08-06 Thread N Pradhan
Exit Function End If Next End Function -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of N Pradhan Sent: Saturday, August 06, 2011 5:28 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extract onl

$$Excel-Macros$$ Extract only mother names

2011-08-06 Thread N Pradhan
I want a formula to extract only mother names as per attached sheet. Please help. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. J

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-15 Thread N Pradhan
sundays =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1 On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote: Dear Sir, Formula required for nos. of sundays between two days. e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010 and 31/01/2011. Thanks & Reg

$$Excel-Macros$$ Nos. of Sundays between two days

2011-02-14 Thread N Pradhan
Dear Sir, Formula required for nos. of sundays between two days. e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010 and 31/01/2011. Thanks & Regards. -- -- Some important links for exce