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

    Check similar entries within the cell

    I have following data in a sheet 110 rows and 39 columns has data (data_range) following is the sample Cell A1 345,267,897 (one cell has 3 numbers) Cell A7 267 Cell D20 345 etc..etc.. Now I have another sheet with nos from 1 to 1000 and in 1 to 1000 rows and I need to mark how many...
  2. V

    Canadian Tax in Spread Sheet

    I have got a spread sheet from a friend which is designed to do Canadian tax. It is formatted in actual tax forms colour and texts. It has all the forms and all data entry figures with all scenerios. Now my assignment is to create 3 print buttons: 1. Print all Forms (including Blank) 2...
  3. V

    Sum of quantities on monthly basis

    Forgot to write right TAGS and help Chandoo link http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/
  4. V

    Sum of quantities on monthly basis

    Just checked it has to be refreshed in order to get latest results. Let me know how can I do an automatic update setting in this Pivot Table.
  5. V

    Sum of quantities on monthly basis

    Pivot table has helped by putting date in row header and pour in pivot values selected for sum and then group date columns to month. But I have to watch if it is getteing updated by itself when new data entry is made. Thanks for the help dear.
  6. V

    Sum of quantities on monthly basis

    I have tried like this so far: Month (Column C) Pour (Column D) Sept 2012 =sumif(A4:A100,C4,B4:B100) where: Column A is the date column in table 1 Column B is the Pour quantity Column in table 1 Column C is MOnth Column in table 2 Column D is Pour Column in...
  7. V

    Sum of quantities on monthly basis

    table 2 need a formula to give the instant numbers if any changes made in data entry in table 1. Adding a row in table 1 can be possibility for to monthly sum and simply forwarding to table 2. But I would rather prefer a formula.
  8. V

    Countif and Sumif functions with multiple criteria

    Use if function to separate the different values Use sumifs for many criteria’s.
  9. V

    Sum of quantities on monthly basis

    I have data base of two columns i.e. Date Pour 21-Sep 422.00 26-Sep 381.00 11-Oct 360.00 17-Oct 414.00 06-Nov 479.00 14-Nov 17.00 I need to sort it in following table: Monthly Progress Total Pour = 6209.00 A B Sep-2012 803.00 Oct-2012 774.00...
  10. V

    Hello .. Introduce yourself

    Hi I am a Civil Engineer and always fecinated with Numbers. Excel is great to keep me busy and Chandoo is great in keeping my interest into it. Thanks dear.
Back
Top