Search:
Type: Posts; User: vks64
Search:
Search took 0.00 seconds.
-
-
sir,
I want to count the number of cells with higher high /lower lows in a row in excel and to compute the value change between the high and higher high (or low and lower low) cells.
I enclose a...
-
Count the consecutive number of positive and negative cells from the current date(from the left) and its sum in excel sheet
I have attached a excel worksheet showing the daily variation in sales...
-
Please Help to learn the basics about macros and to write simple/complex macros thro simple steps?
-
Sub: count the number of colored cells in excel sheet or otherwise count number of cells in increase or decreasing trend.
I have attached a excel worksheet showing the daily sales of six persons A...
-
I have a excel sheet showing sales and sales_return data. I want a excel formula to rank the data values automatically by high to low values (without sorting) as in model excel sheet enclosed....
-
sir,
I have enclosed a sample data in excel sheet.
I want to draw a single candle stick for the data in each of the row (open, High, Low Close)
Additionally, it is preferred that the candle stick...
-
Sir,
Sub: extract data from one excel worksheet to another worksheet
I have a model excel sheet enclosed. The table has a list of shares and their price range for a single day split into various...
-
Sir,
I have enclosed a Question Summary in MS word to describe the question in detail
I have also enclosed one excel table to describe the question and answer required in data format.
I want a...
-
Sir,
In the above illustration all the numbers lie on the same plane and the given numbers may be taken to represent anyone of axis, (in the given example may please be taken to represent the Y...
-
How to calculate the angle between two lines formed by connecting any set of numbers, For Example Line1 formed by connecting numbers 125, 132 and Line 2 formed by connecting numbers 110, 112 in a...
-
-
-
Sir
How to convert the time factor into decimals in the excel sheet?
Please help me with a formula for that
For example
When the Time duration is 1:30:00 ( Time is 1 hour,30 minutes and 0...
-
Sir,
The problem is regarding deleting numerous rows under Data>connections>workbook connections of MS Excel 2010. i.e.. removeal of existing data connections. The MS Excel 2010 does not allow for...
-
Sir,
As suggested, I have checked the workbook but the EDIT LINKS option was found to be “Not enabled”. I believe that there were no links.
However, I found that there are numerous work book...
-
Thank you sir for your continuos replies,
One small mistake regarding the processor, It is intel core i3 processor with windows 7 OS and Not Pentium I3 as mistakenly posted. I believe it is...
-
Sir,
I have attached pdf sheet showing the screen print image of problems faced in excel sheet.
Please help me with a solution
vks64
-
Helpful sir,
I checked my excel sheet and found that there was no links.
I have the following two requirements:-
I want to work further towards the same and to identify the problem in my excel...
-
Sir,
I am interested in the question posted by sarsar 2121.
For the purpose, I badly need to understand the reply posted by yourself sir.
Hence I requested sarsar2121 to put up a sample...
-
Sir,
1)The first part of the question is cut and pasted as quote;
Please help with your reply,
2)Also please help me locate the solution, posted in your reply,
"EDIT LINKS option to...
-
Sir ,
I could not attach a worksheet showing the result, because I could not prepare the results in excel sheet. Hence, I had attached one worksheet with input data and was narrating my requirement...
-
Sir,
I find that during certain times the functions in excel sheet, for example. delete, copy, paste, insert cut cells etc were not working in my excel sheet. I don't know how many other functions...
-
Sir,
I want to delete all blank rows and columns in my excel worksheet and restrict my workspace to the data filled up area. i.e. only the used area must figure out in the excel sheet.
Can...
-
Please post a sample sheet for reference and another sheet showing your desired result
-
Dear members,
I have attached an excel sheet named “Ask me model table” for reference:
1) In the attached table, I have presented the trade data of 10 specific shares for a day, as on 19.11.2012....
-
Sir,
I was using MS Office excel 2007 spreadsheet for drawing stock graph for "volume High Low Close" as below:-
MS Office excel 2007-> insert-> other charts -> stock -> volume-high-low...
-
Hello sir,
I have some excel sheets (15 to 30 nos) containing identical data on certain x number of items; but relates to different dates. Now I need to collate the data pertaining to particular one...
-
Is there any anyway you download breaking news from different websites directly into your computer as and when it happens?
For example: Reuters releases breaking news everyday and how to download...
-
Thank You. It is very useful. I am extremely delighted..
Thank You once again!
vks64
-
Thank you sir. I have my requirement met. But I have to copy the formula over the full field to get the result. And it is not returning the result for time column sir. Finally please explain what do...
-
-
-
-
-
I was using the latest version of ms office 2007 in my laptop but I had learned ms office and ms access respectively in the ms office 2003 and ms acess 2000 version only.
Hence I was comfortable...
-
Dear sir,
For the comfort of explaining I have enclosed a real time data as per the actual requirement
In Data-sheet1,End of the data released by the STock exchange are available as released at...
-
Dear sir,
First accept my apology for not visiting the site for a long period and hence could not attend your remarks.
Now I enclose the sample excel sheet to illustrate my need.
Sheets no 1...
-
I have large numerical data stored in excel sheet. I wanted to write simple formulas to compare the numerical values in the columns A to Z.
For Example to compare the values in columns A,B,C,D of...
-
Sir
I have a set of data in excel sheet A as below:
Sheet A
Name of the students Marks in english Marks in maths
A 45 74
B 38 58
C 52 65
D 45 65
E 88 72
F 36 45
-
I am having a broadband internet connection and I regularly visit the National stock exchange of India website and view the intra day charts and other stock charts provided in the site. Recently...
-
Sir,
Your suggestions were of great use and I would certainly make use of it in simple and smaller applications everyday for which I thank you wholehearted. But I would like to say you that my daily...
-
Sir, You have correctly assessed my view and requirement. The sample enclosed is a selected list of shares traded in the National Stock Exchange of India. Actually the total number of rows in the...
-
Originally Posted by JB
If you'd like assistance on this, post up usable sample sets of sheets with enough data in them for me to show you how to do this. Make sure all the hurdles that need to be...
-
I don't understand the last line '... growing taxfree' Please explain.
-
How to compare related data stored in two or more different excel sheets?
For example, annual sales figure of a number of companies relating to two OR more years available in different excel sheets?...
-
I reside in chennai(formerly Madras) in Tamilnadu state, India. I had purchased a sony ericcson mobile online from an online Trading firm. The supplier was located in a different state (Mumbai...
-
When I download flash content videos from the web (using real Player), it happens that the download gets interupted a number of time resulting in broken downloads (partial downloads).
When I...
-
Please help me
Whether there are any softwares available on the web to prepare detailed charts/graphs showing x and y axis using data stored in MS excel/XML spread sheet?
The chart/graph so...
-
Is there any software available to accelerate the downloading of flash videos (from the web) using a Real Player similar to the download accelerator?
Thank 'U'
|