$$Excel-Macros$$ Data validation help

2014-06-17 Thread Rakesh kumar
Dear Friends, i want to use data validation in excel. first validation - Value would not be repeat in list. and In second Validation , show only those value which is belongs to first value. please find the Sample sheets. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ Urgent required Java developer (Scala) - Indianapolis,IN

2014-06-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: Java developer (Scala)Location: Indianapolis,INDuration: 6-12 Months* *Position: 10* This is an immediate requirement and interview can happen immediately with next day join date. JD: Strong functional programming knowledge, Scala S

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread hari kumar
Networkdays( stdate, end date,[holidays] Thanks & Regards Hari Kumar "Our strength grows from our weakness." On Jun 17, 2014 10:28 AM, "pankaj khairanar" wrote: > Hi Expert, > > I want excel formula for below scenario. > > Date-9=result > > If result=saturday or sunday then omit saturday or sun

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread pankaj khairanar
Thanks Paul! Got the solution and as well knowledge! Regards, Pankaj On Tuesday, June 17, 2014 8:43:44 PM UTC+5:30, Paul Schreiner wrote: > Here we can make use of a couple of different concepts: > #1) Excel stores dates as numbers (the number of days since 1/1/1900). > So, if your date (June

$$Excel-Macros$$ Urgent required .Net developer - Dublin, OH

2014-06-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: .Net developerLocation: Dublin, OHDuration: 3 to 6 months (Extendable)* Visa: US/GC/EAD only Revised skills: What we would need: 1. Object Oriented Programming 2. .NET C# a. Generics, Collections, LINQ b. File

Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread Paul Schreiner
Here we can make use of a couple of different concepts: #1) Excel stores dates as numbers (the number of days since 1/1/1900).   So, if your date (June 3, 2014) is in cell A1, the date 9 days previous to that is A1-9   #2) The Excel function Weekday() returns the "day number" of the weekday.  

$$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread pankaj khairanar
Hi Expert, I want excel formula for below scenario. Date-9=result If result=saturday or sunday then omit saturday or sunday and consider monday. Extample1 02/June/14 - 9=Saturday, May 24, 2014 Want to omit this saturday and sunday want result as Monday, May 26,2014 Extample2 03/June/

$$Excel-Macros$$ Urgent required Python Developer - San Jose, CA

2014-06-17 Thread Gary .
Please respond to *gurjant.si...@damcosoft.com * *Position: Python DeveloperLocation: San Jose, CADuration: 6 months, possibility of extension* Required Skills: •4+ years Python experience. •2+ years Django •2+ years JS with experience on MV* frameworks such as backbone.js or ang

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-17 Thread Rohan Young
thanks a lot bro, this is awesome and that's i need very-2 thanks bro On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi wrote: > PFA > > You need to customize send key letters to get desired output. > > Cheers!! > > > On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young wrote: > >> its already set on b

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
Hi Try second file which i sent today, pl note..either data structure or heading should be unique.. I have prepared second sheet assuming data structure will be same..For working 1st file you need to have same headings in both input & output file. Do let me know where exactly you are finding probl

$$Excel-Macros$$ Auto update Data, Row & Columns

2014-06-17 Thread Rajeev
Dear Experts, Please find attached file and please do the needful as per mentioned in the file. Thanks / Regards, Rajeev -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.face

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi every time I received new sheet from my colleague in. That situation your sheet not working Regards On 6/17/14, Vaibhav Joshi wrote: > I didnt get you what you are trying to say! > > > > > On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta wrote: > >> Hi, >> >> Thanks for the providing me the solu

Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Pravin Gunjal
This is working perfectly as per my requirement. Thanks. Regards Pravin Gunjal. On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS wrote: > Hi Pravin ... > > You can go to Format cell and custom the format of the date which ever > result you need. furthermore you can

$$Excel-Macros$$ Needs help in Data validation

2014-06-17 Thread Rakesh kumar
PFA -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Thanks Brother, But how you Did this. Please explain the process. On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah wrote: > fyi > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com * > > > > > On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar > wrote: > >> Hi Guys, >>

Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Vaibhav Joshi
hi.. if data imported is in date then by using data text t o column you can do easily.. Refer my earlier email.. On Tue, Jun 17, 2014 at 12:19 PM, Pravin Gunjal wrote: > Yes rightly said. The file which has been downloaded from software isn't > having proper systems date format. So I would l

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
I didnt get you what you are trying to say! On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta wrote: > Hi, > > Thanks for the providing me the solution. But I received sheet 1 file > on daily basic in new sheet in that case this file is not working. it > would be very helpful if you provide me sol

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Dhaval Shah
fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com * On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar wrote: > Hi Guys, > > I want to use formula on pivot table data. > > Kindly help me. > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650303464 > > > > -- > Are yo

$$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discus

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi, Thanks for the providing me the solution. But I received sheet 1 file on daily basic in new sheet in that case this file is not working. it would be very helpful if you provide me solution on this Regards On 6/17/14, Vaibhav Joshi wrote: > Hi > > Use this file. > > Cheers!! > > > On Tue, Ju