$$Excel-Macros$$ Excel Interview Question - Help

2011-04-12 Thread Sundarvelan N
Hello Friends, Tomorrow i'm going to attend the Excel handling job intervew. I have been informed that this is going to happen over phone interview also it will be a technical round. Friends could any body shoot the questions which can shoot me tomorrow. Thanks in Advance!!! --

Re: $$Excel-Macros$$ Excel Interview Question - Help

2011-04-12 Thread ashish koul
http://www.excelitems.com/2010/12/excel-vba-interview-questions.html On Tue, Apr 12, 2011 at 3:57 PM, Sundarvelan N nsund...@gmail.com wrote: Hello Friends, Tomorrow i'm going to attend the Excel handling job intervew. I have been informed that this is going to happen over phone interview

Re: $$Excel-Macros$$ Re: Need Small Help to pull values based on the criteira!

2011-04-12 Thread amrahs k
Hi Bhushan, This helps lot and solves my query as well. Thanks for your time and the help. Regards, Sharma On Tue, Apr 12, 2011 at 12:14 PM, Bhushan Sabbani bsabban...@gmail.comwrote: Dear Sharma, Pls find the attachment. pls let me know if there is any problem or the solution was

Re: $$Excel-Macros$$ Need Small Help to pull values based on the criteira!

2011-04-12 Thread amrahs k
Hi Anil, Thanks for your help. This works great. Regards, Sharma On Mon, Apr 11, 2011 at 5:57 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Amrahas, Please check this. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:*

$$Excel-Macros$$ Excel formula help

2011-04-12 Thread vinod rao
Hi, I need a formula adding each month one column. Attached file has a details. Regards, Vin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Drop down button in cell

2011-04-12 Thread rakesh kumar
that's nice.. very handy On Tue, Apr 12, 2011 at 12:30 AM, Ramkesh Maurya sunscel...@gmail.comwrote: ll the options in the Range:List -- Rakesh kumar khowal -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Help with changing Macro

2011-04-12 Thread Dave
I am using Office 2010. I am trying to search and display PDF files in a excel spreadsheet.I got the following macro with help from this group, thanks Ashish Koul. This macro works great I need to modify it some. I want the macro to be able to search the directory based on answers prompted from

Re: $$Excel-Macros$$ Excel formula help

2011-04-12 Thread STDEV(i)
try this formula and see if it helps =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY( On Wed, Apr 13, 2011 at 12:23 AM, vinod rao vinod.ma...@gmail.com wrote: Hi, I need a formula adding each month one column. Attached file has a details. Regards, Vin --