Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread Kush Shama
ed, Nov 23, 2016 at 11:37 AM, sourav devrani < >>>>> souravdevrani1...@gmail.com> wrote: >>>>> >>>>>> in this case if you want to update data on every click you will have >>>>>> to use web scrapping and fetch data from web into e

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-22 Thread Kush Shama
Use import wizard. Select web query and paste the link. On 18 Nov 2016 12:58, "amar takale" wrote: > I want update below link excel.All data show in excel like in website & > update data after click refresh button > > https://www.nse-india.com/live_market/dynaContent/live_ > watch/equities_stock_

$$Excel-Macros$$ First time error

2014-03-19 Thread Kush Shama
Dear team i am using multiple excel sheets. However i am facing a common problem with all files that when i press ctrl+s only then formulas are showing value. Otherwise they are zero. -- 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

Re: $$Excel-Macros$$ counting of a particular denomination

2013-08-29 Thread Kush Shama
u can u with countifs(criteriarange,criteria) and enter > Pl find the attached sheet > > Warm Regards, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama

$$Excel-Macros$$ counting of a particular denomination

2013-08-29 Thread Kush Shama
Dear Team, Please find the attached Excel File. I have two queries; 1. I have certain denomination in range A3:A10. If I wish to know the number of times a denomination has appeared which formula should i use? 2. Adjacent to those denominations there are certain amount of pieces of that denominati

$$Excel-Macros$$ Occurrence of a Denominaton

2013-07-29 Thread Kush Shama
Dear Team I have a Query. Let says I have a column in which multiple denominations are written. for example, A1 contains 1000, a2 contains 100 and A3 contains 500. Lets say I have 140 Such Cells in same column A. If I wish to count how many have a particular denomination, or the number of occurren

$$Excel-Macros$$ array formula

2013-04-02 Thread Kush Shama
I am using multiple sheets in a file. I want to know how to write array formulas(those that are combination of formulas or have a lot of brackets). any simple lead with basic formulas would be very fulfilling. -- Regards Always, Kushlesh Sharma 9907517169 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT