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

    Conditional formatting - Only format days of the month, not previous or next

    Using June as an Example June is J16: P21 Select that edit the Orange CF Use this modified formula =AND(MONTH($J$14)=MONTH(J16),OR(B7=$R$37,B7=$R$39,B7=$R$40,B7=$R$41,B7=$R$42,B7=$R$43,B7=$R$44,B7=$R$45,B7=$R$46)) etc ie: Use the Month of the Month and Month of the Date as an extra check You...
  2. Hui

    Help needed with SUMPRODUCT/SUMIF across multiple columns with criteria

    Oahmed Can you please start a new post and attach a sample file to simplify the solution
  3. Hui

    How to manage an error

    AS debaser described, the On error is still active once triggered If another error occurs it will go back to 10 so you need to a reset statement as described into the end of the error handling to stop that behaviour
  4. Hui

    How to manage an error

    The below is what you want I'm not sure where you want to jump back to, so adjust accordingly Do Until surplus = 0 adr = "AF" & lmin & ":AF" & lmax & "" If lmax - lmin = 0 Then min = Application.WorksheetFunction.Subtotal(5...
  5. Hui

    Excel Doughnut Chart With Round Edges

    You can read more about how this was made here: https://chandoo.org/wp/learn-how-to-make-a-circular-arc-chart-in-excel/
  6. Hui

    [@ function doesn't work

    The outcome should be 13.5, not 10.35 It isn';t working because the Table isn't a Table Select any cell in the Table Ctrl+Shift+T accept headers now try the formula
  7. Hui

    Help Please!! - update this module to work for a Range of cells rather than just 1

    Can you please attach a sample fle
  8. Hui

    Excel picture display!

    This has been answered in several posts and even a blog post about it Try using the Search dialog at the top of the Main Chandoo.org Website
  9. Hui

    Simple copy file macro

    Try: FileCopy "H:\SourceFolder\SourceFileExample.xlsx", "H:\DestinationFolder\SourceFileExample.xlsx" without the Brackets
  10. Hui

    Vba copy and paste

    Can you please attach your file with some sample data so we can better assess the issue
  11. Hui

    Want to save as file in same location with formatting and paste special values without macro

    The only way to save as Values and Formatting is to use: Save As and select a Non-spreadsheet format Try these and see how you go: Note the Text and CSV will loose formatting
  12. Hui

    Loop is breaking in mid.

    Check that the data column has all text or Values?
  13. Hui

    Loop is breaking in mid.

    Can you please post the file so we can see what is going on ?
  14. Hui

    #Value! Cause by external link

    put an =Iferror(existing formula, 0) or =Iferror(existing formula, "") around your existing formula
  15. Hui

    how to calculate time hours simple way, e.g attached

    Use a simple formula like =B1-A1
  16. Hui

    UAE Map Chart

    Have you considered using Power Map instead? It will take addresses as Map References and allow plot of 3D Columns, Contour or shade graphs etc
  17. Hui

    UAE Map Chart

    It is important to know what do you want to do with it ? If you want to map locations against it, do you want the data in UTM or WGS84 format? If you want to simply color the states that isn't important You also want cities ?
  18. Hui

    UAE Map Chart

    Do you want the country, or states ?
  19. Hui

    Correct conversion of decimal inches to feet / inches with fractions

    =IF(A1<0,"-","")&TEXT(INT(MROUND(ABS(A1),1/16)/12),"0' ;;;") & TEXT(MOD(MROUND(ABS(A1),1/16),12),"[>0.999]# #/##;[<0.999]0 #/##") & """"
  20. Hui

    Excel Doughnut Chart With Round Edges

    I missed a part of the original chart So here is an update Also fixed the smoothness of the circle
  21. Hui

    Excel Doughnut Chart With Round Edges

    How about this? See the attached file To understand how it works look at the Named Formula in the Name Manager
  22. Hui

    Data Table inserting a new blank row and write values

    Don Change the last two rows as shown below: Sub WriteData() Dim MstWSName_Transactions As Worksheet Dim MstTblName_Transactions, MaxSrNumber As String Dim O_MstTbl_Transactions As ListObject Dim fnd, rngSearch, Maxrr As Range 'Set Master Worksheet and Master Table for Transactions...
  23. Hui

    Correct conversion of decimal inches to feet / inches with fractions

    =IF(A1<0,"-","")&TEXT(INT(MROUND(ABS(A1),1/16)/12),"0' -;;;") & TEXT(MOD(MROUND(ABS(A1),1/16),12),"[>0.999]# #/##;[<0.999]0 #/##") & """"
  24. Hui

    Correct conversion of decimal inches to feet / inches with fractions

    try the following: =TEXT(INT(MROUND(A1,1/16)/12),"0' -;;;") & TEXT(MOD(MROUND(A1,1/16),12),"[>0.999]# #/##;[<0.999]0 #/##") & """"
Top