Re: $$Excel-Macros$$ Available Consultant HOT LIST PROJECT MANGER AND EMBEDDED DEVELOPER

2013-03-12 Thread David Grugeon
It is just a case of illiteracy. Sales recruiter evidently cannot read or he/she would see that the rules include: 5) Jobs posting is not allowed. Regards David Grugeon On 13 March 2013 14:20, अनिल नारायण गवली wrote: > Dear SalesRecruiter, > > What we do wit this??? > > Kind

Re: $$Excel-Macros$$ Available Consultant HOT LIST PROJECT MANGER AND EMBEDDED DEVELOPER

2013-03-12 Thread अनिल नारायण गवली
Dear SalesRecruiter, What we do wit this??? Kindly mention the problem with sharing a sample data. Warm Regards, Gawli Anil. On Tue, Mar 12, 2013 at 7:13 PM, rajan verma wrote: > what to do with this?? > > > On Tue, Mar 12, 2013 at 7:36 AM, salesrecruiter04 < > salesrecruite..

Re: $$Excel-Macros$$ Data Validation to force users to enter a particular date format

2013-03-12 Thread Bé Trần Văn
Select the column, from the menu on the Format> Cell, appear Format Cells window select the Number tab, for Category select Custom, in the Type in dd- mmm-yy and press the OK button. 2013/3/12 Hilary Lomotey > Hello Gurus, > > kindly help on the subject above. i need the users to enter dates in

Re: $$Excel-Macros$$ RANK formula *

2013-03-12 Thread Hilary Lomotey
Hi Chief i am not sure i fully understand your requirements, if you could explain better and show your expected answers FULLY in a new column at least that might give some perspective or trend for us to follow. for instance if you say Formula should eliminate who are ranking from 1 to 10, which

$$Excel-Macros$$ Data Validation to force users to enter a particular date format

2013-03-12 Thread Hilary Lomotey
Hello Gurus, kindly help on the subject above. i need the users to enter dates in the format dd-mmm-yy, i tired text(a1,"dd-mmm-yy") in DV ,all custom but its not working. thanks -- 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 Fac

Re: $$Excel-Macros$$ If condition

2013-03-12 Thread Abhishek Jain
This should work -- =IF(G2>1,0,IF(AND(C2<41000,G2*8.33%>3500),3500,IF(AND(C2<41000,G2*8.33%<3500),G2*8.33%,((41365-C2)*G2*8.33%)/365))) Although this is based on conditions you told but I think your two conditions are contradictory. See, 3500 bonus will be when bonus wage is 42017...which and

Re: $$Excel-Macros$$ If condition

2013-03-12 Thread Abhishek Jain
This should work -- =IF(G2>1,0,IF(AND(C2<41000,G2*8.33%>3500),3500,IF(AND(C2<41000,G2*8.33%<3500),G2*8.33%,((41365-C2)*G2*8.33%)/365))) On Tue, Mar 12, 2013 at 1:50 PM, Prabhakar S H wrote: > 8.33% on Bonus Wage. > > On Tuesday, March 12, 2013 11:48:37 AM UTC+5:30, Abhi wrote: > >> 8.33% of

Re: $$Excel-Macros$$ Repair File

2013-03-12 Thread Kuldeep Singh
http://www.recoveryfix.com/repair-excel-file.html Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* *

Re: $$Excel-Macros$$ If condition

2013-03-12 Thread Prabhakar S H
8.33% on Bonus Wage. On Tuesday, March 12, 2013 11:48:37 AM UTC+5:30, Abhi wrote: > 8.33% of what ? > > One should not suppose that all people have similar understanding of > problem as the person who is asking for a solution. Last time also, you > missed several things. Please give complete e

Re: $$Excel-Macros$$ Code Automatically

2013-03-12 Thread Chaya
Awesome Anil sir, as i expected you have solved my query. Thanks all for assist. Thanks once again. Sir, Can you please explain me your coding. step by step so that i can understand: Dim a As Integer Set ws = Worksheets("2") Dim b As String irow = ws.Cells(Columns.Count).End(xlToLef

Re: $$Excel-Macros$$ Code Automatically

2013-03-12 Thread Abhishek Jain
I still did not get your query. I have manually done what your code is doing...the data is shifting down because you added 54 rows there, but that's not my point of concern. I also did not understand what you meant by you have to click 6000 times. All your code is doing is copy and paste. Same val