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

    How do I get rid of all TextBoxes in Excel via VBA (empty)

    Thank you very much, this helped me a lot!! @p45cal @Belleke
  2. madocar

    How do I get rid of all TextBoxes in Excel via VBA (empty)

    so instead of AND use two IF functions? how would it look like the whole code? thank you in advance
  3. madocar

    How do I get rid of all TextBoxes in Excel via VBA (empty)

    Hello @Monty thank you for your quick answer. Now I get this error: Is there any way how to fix this? Thank you very much Monty in advance
  4. madocar

    How do I get rid of all TextBoxes in Excel via VBA (empty)

    Hello, please is there any way how do I get rid of all TextBoxes in active sheet that are EMPTY via VBA? There's a ton of them and my Excel got frozen. Thank you for any help
  5. madocar

    Formula language problem

    @Debaser ! Thank you very much You helped me a lot!
  6. madocar

    Formula language problem

    Microsoft 2016 version of 2303
  7. madocar

    Formula language problem

    Hi vletm, thank you for replying. K column - we can ignore. Correct formula is with $DA$5#, so: =D5-SUM(((Table_3[Začiatok prenájmu]<=$G$2)*(Table_3[Koniec prenájmu]>=$G$2)*(INDIRECT("'Prenajatá technika'!AL5:"&ADDRESS(ROWS('Prenajatá technika'!$DA$5#)+4;COLUMN('Prenajatá...
  8. madocar

    Formula language problem

    Hello, I'm from Slovakia and I use excel in Slovak language. I have set some formulas and when It's open in Czech republic, an error has occured. The formula just does not work at all. Sheet name: Error_sheet Formula Cell: G5 Formula: =D5-SUM(((Table_3[Začiatok...
  9. madocar

    Conditional formatting - background color according to cell

    p45cal, thank you for directing me the right way!! :)
  10. madocar

    Conditional formatting - background color according to cell

    Hello vletm, thank you for your feedback. Yes, I have tried to find a lot of information. But never find any so far. Even in this perfect article there is no information about my case. Probably it's too difficult?
  11. madocar

    Conditional formatting - background color according to cell

    Hello, I would like to ask you if there is any way to solve this: There are 50 working groups in column C Each work group is in a different color background in column C Gantt chart is on right side with conditional formatting I would like to apply the same color background in Gantt chart...
  12. madocar

    Stacked bar chart

    No problem! Thanks you again :)
  13. madocar

    Stacked bar chart

    This is really great! Thanks a lot p45cal Perhaps last question, is there any way how to do it without any macro? Thanks again
  14. madocar

    Stacked bar chart

    It would be nice if you can help me out. Yes, you can count with weekends and holidays. Regarding the example - It was just an example - one and a half day :) Of course it will be more. Thanks a lot for any help
  15. madocar

    Stacked bar chart

    Hi everyone, I would like to ask you if it is possible to show following in a chart: Product: Hour it takes to create: Product A 80 Product B 50 Product C 120 One man daily capacity (this might change dynamically): Daily capacity [Hour] till 15.6.2019 15 till 30.6.2019 10...
  16. madocar

    Showing Product production in line

    Hi everyone, I would like to ask you if it is possible to show following in a chart: Product: Hour it takes to create: Product A 80 Product B 50 Product C 120 One man daily capacity (this might change dynamically): Daily capacity [Hour] till 15.6.2019 15 till 30.6.2019...
  17. madocar

    Get decimal number with zeros

    You made my day Hui .. Thanks a lot
  18. madocar

    Get decimal number with zeros

    Hello, is there any way how to extract decimal numbers with zeros? Example: Number: 1,6 =VALUE(MID(MOD(1,6;1);FIND(",";1,6)+1;2)) = 6 I want to get value 60 Is there any way how to get two decimal numbers please? Thanks for any help
  19. madocar

    Convert to currency format in excel formula

    Once again please, it must be the formula. I know how to format the currency by clicking on the cell >format cells ... Thanks
  20. madocar

    Convert to currency format in excel formula

    It must be the formula. I come from EU so formula =DOLLAR(B4, 2) gives me EUR sign instead of dollar sign.
  21. madocar

    Convert to currency format in excel formula

    Hi, please is there any way how to convert number format (1 345) to currency format ($1 345) by using a formula? I tried this formula =TEXT(B4,"[$$-C09]# ##0") but finally it happened to be a text string. Thanks for any help
  22. madocar

    Equation in text format convert to value

    Thank you @NARAYANK991 @Chihiro
  23. madocar

    Equation in text format convert to value

    Is there a way to convert string (equation) to equation able to be calculate. Original format (column A): 22 y 180 d 5 h Required format 8210,208333 (days) Substitute formula helps a lot (column B). =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A9;" y ";"*365+");" d ";"+");" h";"/24") But I'm still...
  24. madocar

    Multiple cells merged to one cell - array condition

    Hi Bobhc, I need to put those merged values to the text box. That's why I need to make them merged. Thanks
  25. madocar

    Multiple cells merged to one cell - array condition

    Hi everyone, I would like to ask you if it is possible to do this: According to date in column B (1.12.2016) I would like to get values from column C, merged to one cell separated by char(10). More in attachment. Thanks for any help
Back
Top