Hi,
Can someone help me on why Alt I+R is not working?
I am using excel 2007.
It was working till few days ago but not now. I am using Alt + H + I + R to
add rows.
Thanks in advance.
Regards,
Sharad
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Dear Experts,
Please help me in calculating operating days in the attached sheet.
There are 2 contracts which will run after one after other. These start and
end at particular days. There is gap of some days between start of 2nd
contract and end of 1st contract. I need to calculate that for how m
Dear Experts,
Can someone please let me know how to lock only selected cell?
Thanks,
Sharad
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Hi,
Can someone give me a formula for calculating the discounting factor to get
present value of monthly interest payment?
Regards,
Sharad
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use conc
Hi All,
Can you someone help us in putting the attached data in four quadrants
chart in excel? We need name of the company against its dot.
We have tried the following url, however it does not allows us to put names
on dots.
http://www.teylyn.com/articles/excel-articles/xy-scatter-chart-with-qua
Hi David,
Thanks a lot for your help on this. Really appreciate.
Best Regards,
Sharad
On Tue, Aug 14, 2012 at 3:19 PM, David Grugeon wrote:
> Sorry. I worked it for each input value being the cash flow for a year.
> I see that you have put down a "Year 0" and the cash flows for the Year 0
>
Hi,
I need a formula or macro for calculating payback period which is dynamic.
I mean that it can calculate the payback period for series of data without
changing the formula itself again again.
I am attaching an example sheet with 3 scenarios where we can have same
formula / macro.
Will appreci
OORAIN ANSARI wrote:
>>
>> Dear Sharad,
>>
>> It is working on my system. once again Please press on scrolllock button.
>>
>>
>> On Wed, Aug 1, 2012 at 4:38 PM, sharad jain wrote:
>>
>>> Hi All,
>>>
>>> I can not move my cur
Hi All,
I can not move my curser directly in excel while editing.
In the attached example, if I want to make B2 to A2. I can not do it
directly. I have to actually type it in place of B2.
Can someone help?
Thanks.
Sharad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use conci
Priyanka,
Can you please explain in detail?
Thanks,
Sharad
On Mon, Feb 13, 2012 at 3:20 PM, PrIyAnKa wrote:
> Dear Sharad
>
> Do u use ODIN? if yes then recent prices can be get directly from there
>
>
> On Mon, Feb 13, 2012 at 3:07 PM, sharad jain wrote:
>
>> Than
Thanks Maries,
However, I am not able to download any price data.
Regards,
Sharad
On Mon, Feb 13, 2012 at 10:25 AM, Maries wrote:
> http://www.mrexcel.com/tip103.shtml
>
>
> On Mon, Feb 13, 2012 at 8:37 AM, sharad jain wrote:
>
>> Hi Experts,
>>
>> Can
Hi Experts,
Can anyone suggest a way to directly download the prices from NSE website?
I can provide ticker in a cell.
I am talking about downloading the latest price following url:
http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD
Please treat this a
ion in Get External Data.**
> **
>
> ** **
>
>
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *sharad jain
> *Sent:* Jan/Wed/2012 11:52
>
> *To:* excel-macros@googlegroups.com
> *Subje
Hi,
Is there any way to extract current / closing price of a particular share
from NSE website in an excel sheet?
Thanks,
Sharad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi All,
I have PDF containing record of more 200 companies and running into 35
pages into the form of table.
I am using the free version of PDF.
Is there any way that I can import the table into excel.
Thanks,
Sharad
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise,
Sat, Oct 29, 2011 at 12:11 PM, sharad jain wrote:
>
>> Hi Experts,
>>
>> Is there an option to remove the page no in background when a section in a
>> sheet is viewed in Page Break Preview?
>>
>> Thanks in advance.
>>
>> Best,
>> Sharad
&g
Hi Experts,
Is there an option to remove the page no in background when a section in a
sheet is viewed in Page Break Preview?
Thanks in advance.
Best,
Sharad
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Hi Guys,
Can someone please send me a simple code for round off to nearest 10? (No
macro if possible.)
For example, if I put 23 in A1, it should result in 20 in B1 and if I put 27
in A1, it should result in 30 in B1. For 25, it should result in 30.
Thanks in advance.
Best,
Sharad
--
-
I have alread tried that.
I have put date range as 1-Jun-2010 to 21-Jun-2011.
On Wed, Jun 22, 2011 at 9:17 PM, ashish koul wrote:
> chage the date in cell d2 and f2
>
> and client in b2 and then run the macro
>
>
> On Wed, Jun 22, 2011 at 7:35 PM, sharad jain wrote:
Thanks Ashish,
But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.
Also can you please let me know how create this type of macro?
Thanks,
Sharad
On Wed, Jun 22, 2011 at 7:18 PM, ashish koul wrote:
> try this
>
>
> On Wed, Jun 22, 2011 at 5:59 PM, Ketan wrote:
>
>> Dear Members,
20 matches
Mail list logo
