Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: vks64

Search: Search took 0.00 seconds.

  1. Thanks sir

    Thanks sir
  2. count the number of cells with higher high /lower lows and change in value

    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...
  3. Count the consecutive number of positive and negative cells from the current date

    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...
  4. Answers
    0
    Views
    316

    Learn to write macros

    Please Help to learn the basics about macros and to write simple/complex macros thro simple steps?
  5. count the number of colored cells in excel sheet

    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...
  6. Answers
    1
    Views
    766

    Ranking data by value

    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....
  7. Answers
    1
    Views
    616

    how to draw a single candlestick in excel

    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...
  8. extract data from one excel worksheet to another worksheet

    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...
  9. Sub: data to be Updated automatically under the respective heads in an excel sheet

    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...
  10. Sir, In the above illustration all the numbers...

    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...
  11. How to calculate the angle between two lines formed by connecting any set of numbers?

    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...
  12. Answers
    2
    Views
    850

    Yes sir vks64

    Yes sir
    vks64
  13. Answers
    2
    Views
    1,432

    Thank You Sir!

    Thank You Sir!
  14. Answers
    2
    Views
    1,432

    Convert time into decimals in excel worksheet

    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...
  15. Answers
    12
    Views
    1,784

    Sir, The problem is regarding deleting...

    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...
  16. Answers
    12
    Views
    1,784

    Sir, As suggested, I have checked the workbook...

    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...
  17. Answers
    12
    Views
    1,784

    Thank you sir for your continuos replies, One...

    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...
  18. Answers
    12
    Views
    1,784

    Sir, I have attached pdf sheet showing the...

    Sir,

    I have attached pdf sheet showing the screen print image of problems faced in excel sheet.
    Please help me with a solution
    vks64
  19. Answers
    12
    Views
    1,784

    Helpful sir, I checked my excel sheet and found...

    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...
  20. Sir, I am interested in the question posted by...

    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...
  21. Answers
    12
    Views
    1,784

    Sir, 1)The first part of the question is cut...

    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...
  22. Answers
    12
    Views
    1,784

    Sir , I could not attach a worksheet showing...

    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...
  23. Answers
    2
    Views
    850

    Selected functions not working in excel sheet

    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...
  24. Answers
    12
    Views
    1,784

    Delete blank rows and columns in excel worksheet

    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...
  25. Please post a sample sheet for reference and...

    Please post a sample sheet for reference and another sheet showing your desired result
  26. Answers
    0
    Views
    1,303

    modulation of data in excel spread sheets

    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....
  27. Answers
    1
    Views
    503

    Stockcharts in excel spreadsheet 2007

    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...
  28. Collating information available on excel sheets

    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...
  29. Downloading of news contents directly from websites

    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...
  30. Question: Excel spreadsheet

    by vks64
    Answers
    7
    Views
    1,151

    Comment on JBeaucaire's post

    Thank You. It is very useful. I am extremely delighted..
    Thank You once again!
    vks64
  31. Question: Excel spreadsheet

    by vks64
    Answers
    7
    Views
    1,151

    Comment on JBeaucaire's post

    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...
  32. Comment on JBeaucaire's post

    Thank You
  33. Question: Excel spreadsheet

    by vks64
    Answers
    7
    Views
    1,151

    Comment on JBeaucaire's post

    Workbook enclosed
  34. Question: Excel spreadsheet

    by vks64
    Answers
    2
    Views
    679

    Comment on JBeaucaire's post

    Thank You
  35. Answers
    2
    Views
    421

    Comment on ScottGem's post

    Thank You
  36. Answers
    2
    Views
    421

    To work on a lower version

    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...
  37. Question: Excel spreadsheet

    by vks64
    Answers
    7
    Views
    1,151

    Dear sir, For the comfort of explaining I have...

    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...
  38. Dear sir, First accept my apology for not...

    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...
  39. Question: Excel spreadsheet

    by vks64
    Answers
    2
    Views
    679

    excel spreadsheet

    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...
  40. Question: Excel spreadsheet

    by vks64
    Answers
    7
    Views
    1,151

    Excel spreadsheet

    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
  41. Answers
    1
    Views
    1,276

    Unable to browse the site with add-ons enabled

    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...
  42. Sir, Your suggestions were of great use and I...

    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...
  43. Sir, You have correctly assessed my view and...

    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...
  44. Originally Posted by JB If you'd like...

    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...
  45. Question: Anuitty tables

    by vks64
    Answers
    6
    Views
    1,553

    I don't understand the last line '... growing...

    I don't understand the last line '... growing taxfree' Please explain.
  46. Compare related data stored in two or more excel sheets

    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?...
  47. Jurisiction of courts in case of online purchases

    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...
  48. Continuing flash video downloads from the broken link in a real player

    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...
  49. Answers
    2
    Views
    1,667

    preparing charts using excel data

    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...
  50. Answers
    1
    Views
    3,407

    Accelerate download speed in realplayer

    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'
Results 1 to 50 of 61