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

    correlation coefficient - statistics analysis debugging.

    Hi, I have a statistical analysis report and would like to hire someone to fix the entire reports on the excel. I have got a serious issue on the correlation analysis. Basically, I dont know how to do this. had an assignments on statistics that i had a raw data related to smoking survey , the...
  2. paulcherianc

    Search text on all Worksbooks and Copy Paste entire Row (Help on Merged Cells)

    Hi, I was developing a macro to search the user given text on any cell and if found copy paste entire row from Column A till the end of that particular row to a new sheet on the macro workbook. I think its working except on the merged fields. Can any experts help me to sort it out. Macro...
  3. paulcherianc

    Auto Fill Down

    Dear Ninjas, How can i make the following code to a single string! Sub lastRow() Dim lastRow As Long lastRow = Range("B" & Rows.Count).End(xlUp).Row Range("C41").AutoFill Destination:=Range("C41:C" & lastRow) Range("D41").AutoFill Destination:=Range("D41:D" & lastRow)...
  4. paulcherianc

    Date Calculations

    Hey Thanks Hui. Thanks for your time!
  5. paulcherianc

    Date Calculations

    Hi, can anyone help me to fix the following formula. I have attached a sample for better understanding. I want to see the following results on the attached sheet Grace Period (90 days after renewal date) Valid (<=Renewal Date) Expired (>Grace Date) Can anyone build the logic.
  6. paulcherianc

    Autofiltering error 1004

    Hi, Based on the dates provided on the cells "I1" and "J1" (linked "S3" where the user will input on going month date) the macro will auto filter "B5:Y" on the following: 1. First filtering will be done on Contract Signed ("F5") and copy the filtered data to the table then macro will delete...
  7. paulcherianc

    Countifs between dates

    Perfect! Thanks Chihiro!
  8. paulcherianc

    Countifs between dates

    Oops can you see the results? But i can see only zeros.
  9. paulcherianc

    Countifs between dates

    Should i use sumproduct instead?
  10. paulcherianc

    Countifs between dates

    Ok. I have uploaded a sample file. Thanks in advance!
  11. paulcherianc

    Countifs between dates

    I am trying to get the count of all records with in these dates.
  12. paulcherianc

    Countifs between dates

    Am sorry, Right formula is: =COUNTIFS('NEW REGISTER'!$I$6:$I$5001,"<=12/31/2014",'NEW REGISTER'!$I$6:$I$5001,">=1/1/2014")
  13. paulcherianc

    Countifs between dates

    Dear Experts! Can you please check the formula given below. I am not getting results. =COUNTIFS('NEW REGISTER'!$I$6:$I$5001,"<=" &"31/1/2014",'NEW REGISTER'!$I$6:$I$5001,">="& "31/12/2018")
  14. paulcherianc

    Sum Product

    Wonderful! Thanks a lot, Narayan!!!
  15. paulcherianc

    Sum Product

    Yes. My main file contains mix of currencies.
  16. paulcherianc

    Sum Product

    This is for automatic calculation when we change each month head.
  17. paulcherianc

    Sum Product

    It's working perfectly. Can you please help me to fix the currency as stated on the new attached file. Thanks in advance!
  18. paulcherianc

    Sum Product

    Dears, Following formula is giving "Value" error. Can you please fix my issue. =SUMPRODUCT(--(X$3:BL$3=S1),A$4:A$49,AH$4:AH$49) I have attached a sample file for your review. Thanks in Advance!
  19. paulcherianc

    Sumif on date range.

    Here is the file.
  20. paulcherianc

    Sumif on date range.

    Guyz its fine. I have found the formula to do this. =SUMIFS(D4:U4,$D$3:$U$3,">="&$B$1,$D$3:$U$3,"<="&$B$2) Thanks!
  21. paulcherianc

    Sumif on date range.

    Hi, Is there any way to get the sum of a date range with sumif formula? I have attached the sample file. please help!
  22. paulcherianc

    Auto Numbering (Serial Number)

    Many thanks Narayan!
  23. paulcherianc

    Auto Numbering (Serial Number)

    Can anyone help me to create a formula to do auto serial numbering on a table based on the item description? If the item is duplicated, then the particular serial number should be increased. in the following example look into "item 1"; where you can see the SN 1,2,3,4. SN Item Description 1 1...
  24. paulcherianc

    Custom UI Editor For Microsoft Office Doubt

    With the following XML code I can see only one group. Can anyone advise me how to add a New Group to the ribbon bar? <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon> <tabs> <tab id="Tab1" label="QUICK FIX"> <group id="Group1" label="Time Saving Tools"> <menu...
  25. paulcherianc

    Add sheets- all months

    It is deleting all existing sheets and creating 12 additional sheets with month and year!
Back
Top