• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    data as picture to be shown on button click

    I want to show certain range of data as pop up picture. how to do it.
  2. S

    Formulas for averages automatically updated when new column inserted

    Hi, Kimber my solution to your problem is like this (may be better solution available) column a b and c are for average 3 months, average 6 months & average 12 months. from column d to "n" number of columns (i have taken up to column y) are for months which every month you add one month. put...
  3. S

    select data from different sheets

    Hi SirJB7, Now, I have correctly understood Indirect Function. Thank you very much. Regards. satish
  4. S

    select data from different sheets

    Sorry Sir! I should have mentioned that problem is solved. I have written that I had no idea ...... is my lack of knowledge about function Indirect, before getting your help. Thank you.
  5. S

    select data from different sheets

    Thanks Hui Sir and SirJB7. I have tried lot but I have not used indirect function rather I had no idea about how Indirect function can be used. Thank you very much.
  6. S

    select data from different sheets

    Hi, Thanks in advance. I have data stored for 10 locations, for each day in 12 monthly sheets. Now I want to pick up data for particular date in a year in report sheet. Depending on month I could not fetch data. I am not able to give sheet name(march in following example) through formula...
  7. S

    LISTS IN EXCEL

    EXCEL ALLOWS TO ADD LISTS. BUT HOW TO USE LISTS LIKE USING NAMES IN FORMULA
Back
Top