$$Excel-Macros$$ Login password in excel

2014-04-17 Thread amar takale
-- 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 thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ get jobs update daily in MIS!!

2014-04-17 Thread Amresh Maurya
login your facebook and Like this page if you are MIS professionalshttps://www.facebook.com/misprofessionals and Get Jobs update daily. https://www.facebook.com/misprofessionals Thanks! AK -- 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) !

Re: $$Excel-Macros$$ Login password in excel

2014-04-17 Thread Prafull Jadhav
Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain abhishek@gmail.com wrote: Dear Amar, Please see the attached file. I hope this works for you. You may login by using any of the following credentials (both username and password

$$Excel-Macros$$ Sort Dynamic range - Help needed

2014-04-17 Thread SG
Hi Experts, I need a solution to sort the data on basis of location highest marks. For this, i have created a dynamic named range to call it by macro then sort. My problem comes when the range also selects the blank formulas in sheet which shouldn't be selected. Only visible data should

Re: $$Excel-Macros$$ Sort Dynamic range - Help needed

2014-04-17 Thread vba
PFA Thx On Thu, Apr 17, 2014 at 1:28 PM, SG sonal...@gmail.com wrote: Hi Experts, I need a solution to sort the data on basis of location highest marks. For this, i have created a dynamic named range to call it by macro then sort. My problem comes when the range also selects the blank

Re: $$Excel-Macros$$ Sort Dynamic range - Help needed

2014-04-17 Thread SG
Hi vabz, Thanks for the reply but this is not solving my purpose.The data is not sorted on location highest marks i don't want to paste the visible data anywhere else. The sorting done only at that location i.e from colun A to D. On Thursday, April 17, 2014 2:02:46 PM UTC+5:30, Vabz wrote:

Re: $$Excel-Macros$$ Sort Dynamic range - Help needed

2014-04-17 Thread vba
Hi PFA, result can be achieved using pivot table dynamic reference. Thanks On Thu, Apr 17, 2014 at 2:25 PM, SG sonal...@gmail.com wrote: Hi vabz, Thanks for the reply but this is not solving my purpose.The data is not sorted on location highest marks i don't want to paste the visible

Re: $$Excel-Macros$$ Automating a goal seek using an excel formula

2014-04-17 Thread gabriel denis
You can easily do so using the IRR function. You simply have to add your set NPV to the cashFlow at time 0 and look what your IRR is going to be. By definition, that irr is going to be the discount rate that permit you to obtain your set NPV. Le jeudi 21 juin 2012 05:21:40 UTC-4, ANKUR

$$Excel-Macros$$ Excel subtotaled worksheet

2014-04-17 Thread joe
How do I convert a subtotaled spreadsheet with 1000 lines into a short list of only the totaled lines? -- 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

$$Excel-Macros$$ Additional Control

2014-04-17 Thread Falina Gan
To Whom It May Concern, May I ask, why can;t we click the additional Controls to create a new calender? Here is the image as below:- Thanks. https://lh3.googleusercontent.com/-W66RRb-bSOE/U1C735uHbiI/AGs/QMrtJZswwsc/s1600/additional+control.png -- Are you =EXP(E:RT) or