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

    Sumif

    Dear Mr Chandoo I have a problem. I have two columns viz., challan date and amount as under.... the data I have to analyse is for one or two years. I want to sum monthwise for the challans and sometimes i want to sum along with customer code. Can you please explain me use of SUMIF and...
  2. I

    IF CONDITION

    I have to calculate rate of duty from 1.4.2005 to 29.02.2008 @ 16% From 1.3.2008 to 6.12.2008 the same is to be @ 14% and from 7.12.2008 to 23.02.2008 it has to calculated @ 10% and from 24.02.2008 onwards it should be @ 8% I have Invoice Date in A2 and I have Gross Value in d2 and I want the...
  3. I

    Fill - Justify

    Dear Chandoo You have explained us to use Fill - Justify for bringing the data in a single row. Now I have a data wherein A3 to A6, A7 and A10, A12 to A16 and so on till A35454. Is there any way I can get all these data i.e. A3 to A6 in B3 and so on... The option Fill - Justify can be...
  4. I

    Gap Detection

    Sir, How to find the gap in a continuous serial no using Excel For Example Invoice No 110102870 110102871 110102874 110102875 110102876 110200001 In the above data 110102873 is missing and the serial number 110200001 is totally new and hence from 110102876 to 110200000 should be...
Back
Top