• 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. aamirsq

    Searching Table Skipping/without Zero

    For Option 2 and 3 ! I use mostly office 2013, sharing would create problem also noticed when any company is completely removed summary gives error in Option 2. Option 1: :cool: But I prefer formulas instead of vb, as while sharing people are afraid of script codes:rolleyes: and even sometimes...
  2. aamirsq

    Searching Table Skipping/without Zero

    Well, the problem is not N6 its M6 :). I want to write in M all companies for which 6 came in one column.
  3. aamirsq

    Searching Table Skipping/without Zero

    Hi, Greetings Happy new year 2017, I am trying to create a summary from a table but zeros are making problem for me. Any ideas. I just want to add only products which were sold to any company. Thanks
  4. aamirsq

    Need help on Ms Access

    Apologies, But had no other option.
  5. aamirsq

    Need help on Ms Access

    Hi Guys & Grlz, I was working on this database and got stuck, i hope some one can help? The idea is "A company keeping tracking of renting equipments and customers. The customer can take multiple equipments. Each equipment has a unique ID. (alphanumeric - XXXX#####) depending on the selection...
  6. aamirsq

    Conditional Formatting with Icon Set on Text Cell

    Hi, Is it possible to make the custom icon set appear beside TEXT cell ? I could not find nice icon any recommendations would be appreciated :)
  7. aamirsq

    Linking chart with table in excel

    What i do is "from sheet 1, i select all [A2:M4] data and click recommended charts style 2." extremely simple. So what else did you do with it ?
  8. aamirsq

    Linking chart with table in excel

    Hi, I am having little problem here anyone with suggestion ? i want to display in chart data only upto selected month.
  9. aamirsq

    Better alternative to MS Excel

    Well now there is Google spreadsheet available btw i am not fan of excel but i always most of my solutions in excel. i wish excel could use filter as easy as Google, import other files as easy as Google.:rolleyes:
  10. aamirsq

    How to Draw a Polar Chart

    Great work. i was also looking for this :)
  11. aamirsq

    How to get data from different sheet

    i hope this will work for u. make unique Id of all your PSM IDs on one sheet and use index match to search data.
  12. aamirsq

    Search and move data to other sheet

    adding the helper column did work but there is still a problem the values for January are not coming correct as it is counting the values for sub tasks as well.
  13. aamirsq

    Search and move data to other sheet

    Hi, how can i search and move date to other sheet as shown on sheet 2.
  14. aamirsq

    Hi, I want to change my display ID ? how do i do that?

    Hi, I want to change my display ID ? how do i do that?
  15. aamirsq

    Adding the previous quantities

    and for average ? i just used average instead of SUM. :) Thanks a lot
  16. aamirsq

    Adding the previous quantities

    my bad https://docs.google.com/spreadsheets/d/12s7TN1ZJz_j5SGSmT-K_efOmZsztRpqGV67gAqqGVIw/edit?usp=sharing spreadsheet
  17. aamirsq

    Adding the previous quantities

    Hi, i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working H1 : is my selection month Row B3:M3 is my date Row B4:M4 is my data which is i am adding using above formula.:awesome: Thanks
  18. aamirsq

    Excel Survey Calculation

    works great and what if i want to increase (decrease) the number of question or number of choices (4 to 6) ?
  19. aamirsq

    Excel Survey Calculation

    i want to calculate the survey result based on my data.
  20. aamirsq

    Linking excel data with visio

    Hi, Did anyone tried to link excel data with visio 2013 to create graphs ? I was trying to link excel data with visio by: (try any data) so if i change value i excel it should also reflects in visio graphs. In Vision 2013, Under Data Menu >Link Data to Shapes >Data Graphics I like...
  21. aamirsq

    Chart help ..

    Look at project 5 and project 7. project 7 will be reject as it will not fall with in our calender but project 5 will over drawn as it exceeds our calender.
  22. aamirsq

    Chart help ..

    That was quick reply, but if you notice the date i want is in financial year and that's fixed if "end date falls with that date chart would look fine but if date goes above my FY13. it should plot whole line. (look project 4) I was thinking about putting an extra column and hiding it but still...
  23. aamirsq

    Chart help ..

    Hi, I m really tired today, i wanted to make a chart like shown. how can i make . thanks
Back
Top