Search results

Hi there, I am trying to calculate the workdays in a month according to a unique shift model, but I am stuck. The summary: The hours for each shift are spread over a 6-day workweek that runs from Monday through Saturday. Bank holidays must be taken into account. The 1st shift is 8 hours long...

Hi everyone, I would like to ask you to support me. The problem : how to "sumifs" the sales view based on "Customer" and "Calendar Month Historical" but the "Calendar Month Relevant" needs to be smaller or equal to the Calendar Month Historical. The tricky part is that, I can only retrieve...

Hello, I would have a question regarding the "sumifs" of merged cells, it is inspired by a formula challenge in 2013. Here is the path to the thread: https://chandoo.org/forum/threads/formula-challenge-021-sumif-in-merged-cells.11927/ The question: how to sum the values with criteria? The...

Hello, Could you please give me support to create a bar chart regarding project milestones visualisation? My problems are: 1. the start and end dates of project milestones are stored as weekweek.yearyearyearyear 2. the duration of project milestone with start and end week have to be presented...

Hello, I would need your support to find the first non-blank text cell based on multiple criteria but without array formula. The original file has more 10.000 rows and the calculation time of my array formula takes long time. Please, see the details and expected result in the sample file. Do...

Hello, I would like to ask some advice regarding font size modification (in Excel 2013 or above), because I do not find the correct way and I am lost. The below mentioned code copy the Excel range then paste it in powerpoint but unfortunately I cannot change the font size (6 to 8) of...

Hello, I would need your support regarding bar chart creation. The details and expected results are in the attached file. Thank you in advance any feedback!

Hi, I would like to ask your help regading the conditional formatted cells counting. In range B9:C19 I applied 4 different conditional formatting rules (colours: red, orange, yellow, green) and my target is to count those cells which are formatted with red, orange and yellow. The sample file...

Hi, I would need your help to create a gear wheel chart, please see the sample picture in the attached file. Thank you for all your guidance!

Hello, I would like to ask some help regarding that how to find a value based on criteria and partial text. There is one condition: the different partial texts should be managed inside the formula (not store in range). I have atteched a sample file with the desired results. Thank you in...

Hello, I would like to ask that what is the fastest way to remove all letters from a range in one shot? In range G9:G the numbers ended with base units, like PC, KG or L and etc. Could you help me to figure out a code which can remove all letters (English Alphabet) from this range? This is the...

Hello, I would need your help to solve a date format problem. I use the below mentioned code but doesn't work well. Option Explicit Sub Test() Dim OutputSheet1 As Worksheet Dim OutputLastRow1 As Long Set OutputSheet1 = Worksheets("Calculation") With OutputSheet1 OutputLastRow1 =...

Hello, I would need your help to find the 2nd value based on two criterias (Storage and Order number). Please, find attached my sample file with the desired result (cell M9). Thank you in advance the help!

Hello, I would like to reproduce a radial bar chart but i can not figure out, could you please help me to do this?

Hi, I would like to ask your help regarding data transfer from closed workbook. After many attempts I feel that I am completly lost. The attached Components.xls file generated by SAP and when I want to transfer the data I receive "External table is not in the expected format" error message. By...

Hello, I would like to ask that how is it possible return blank cell if the result of worksheet function is 0? With Sheets("Evaluation") Lastrow = .Cells(.Rows.count, "B").End(xlUp).Row .Range("AN9:AP" & Lastrow).ClearContents .Range("AN9:AN" & Lastrow) =...

Hello, I would need you advice regarding blank cell displaying. In my sample file I search the target value based on 2 criterias, it is working fine but if the formula doesn't find anything then turn to 0. i would like that if the formula doesn't find anything then turn to blank cell instead...

Hello, I would like to ask some help from you regarding the chart updating. I use this code to create chart about the data source: Sub WeeklyChart() Dim SourceSheet1 As Worksheet Dim SourceLastrow1 As Long Dim cht2 As Chart Set SourceSheet1 = Worksheets("Evaluation") With SourceSheet1...

Hello, I would like to ask some help to create a chart based on the given data (you can see in the sample file). To represent the desired result I just colored the background of the cells. Thank you in advance the reply!

Hello, I use the below mentioned part of code to send mail with reminder but my problem is that regarding the reminder: How to set the next calendar working day? Could you please give some advice how should I set this? With OutMail .To = "" .CC = "" .BCC = "" .Subject = "" &...

Hello, I would need your help regarding jpg creating. My question would be that: how is it possible to set the range until: ("A1:AP" & Lastrow)? In my file the content of this range is changing each day therefore I would like to handle "dynamically"... somehow. This the code what I have now...

Hello, I struggle with big data and I do not see the light the end of tunnel. In my sample file I would like to calculate the monthly inventory value by distinct company and material the code is working fine just the problem is that the total calculation time is: 20 sec. :eek: The original...

Hello, I would like to ask that is there any kind of way to display all column labels of pivot table and then sort them by ascending order thru VBA (after refreshing)?

Hello, I would like to ask some help regarding a rounding issue. In my sample the target is that to display rounded the values (which are in the Pivot table) based on the packaging rules but I can not figure out how should do it. Could somebody help me? Thanks in advance the reply!

Hello, I would like to ask that how is it possible to count the unique values based on criteria if the repeating values are in 2 columns (unfortunately, I can count only that case if the repeating values are in 1 column)? Additional info: the range of repeating values (sheet Evaluation R9:S...