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

    Sumproduct at each change in voucher no

    Thanks Hui for the quick response. I could not understand, only if you would give me an illustration. I have also tried to post the data (though not very successfully by text file).
  2. N

    Sumproduct at each change in voucher no

    Date Particulars Vch No. Quantity Rate ucp total 08/04/2010 Bhandari SR-TN/1/10-11 -2 No. -Rs.2,670.00 9644YM08 -1 No. 1275.00/No. 2451YM02 -1 No. 1395.00/No. 12/04/2010 Ajay TN/0001/10-11 1 No. Rs.2,650.00...
  3. N

    Sumproduct at each change in voucher no

    Dear Clarity, No I am not referring to one unique voucher no. I have a column with many voucher numbers (rows) and I wanted a sumproduct of each voucher no. Is there any way I can post the excel data sample for easy understanding?
  4. N

    Sumproduct at each change in voucher no

    I was having to manually put a subtotal formula for large amount of data. I have a column where I want result of sumproduct of two columns at each change on voucher no (another column). I just want to copy the formula for the whole column rather than manually calculating it (no of rows will keep...
Back
Top