Contact Kishan

Add Kishan in your Gmail/GTalk:

Circle Kishan on Google+
Google+ Profile: +Kishan

Circle Page "iGoogleDrive" on Google+
iGoogleDrive Google+ Page: +iGoogleDrive

Add Kishan as your friend on Facebook:
Facebook: Kishan+

Like Page "iGooglePage" on Facebook:
iGoogleDrive Facebook page: iGoogleDrive


  1. Hi Kishan
    Would you please take a look at this ...

    The idea is to present lists of stocks showing their % Change from ‘specific dates to Today’ with their associated sparklines, sortable by any column. Right now data history for sparklines is static; it needs to update daily automatically with each day’s new data so the sparklines stay up to date.

    %Change data comes from column G (Today’s quote) and column E and column I (specific historical date).

    The current design sorts the table correctly only if the sparklines are deleted. When sorted with the sparklines in place the sparkline output is garbled. I think the sparkline data needs to be stored in Sheet2 but it’s beyond my ability to get it right.

    Then to make this work properly need to find a way to enlarge individual sparklines to about 7x4” for clarity. Hyde suggested ‘maximize/minimize buttons next to each sparkline separately to run scripts to change row height and column width as necessary’’

    Sparklines are a terrific way of presenting visual data in cells and work even better when they can be sorted in order with their associated numerical data.

    Your help is greatly appreciated.
    Many thanks

  2. I love your code here Could you modify it perhaps to check for duplicates in the 'selected' range. This way I wouldn't have to change the code between duplicate searches.

    I can't believe Google (or Microsoft for that matter) hasn't made their own tool for such a common task.

  3. I am trying to use Google Forms to collect information. Based on the answers chosen, I want to calculate a score. Here is a link to the Form I created, and one to the scoring I want used (See the end.). How do I make this happen?