Search results

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

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

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

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

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

Microsoft 2016 version of 2303

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á...

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

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

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?

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

No problem! Thanks you again :)

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

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

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

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

You made my day Hui .. Thanks a lot

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

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

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

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

Thank you @NARAYANK991 @Chihiro

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

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

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