Search results

Greetings Shafiey, Thanks a lot for your inquiry. The site you have provided is behaving dynamically as it is working with Javascript. Because of the javascript integration, it isn't easy to extract info from there. Even the table that you are seeing is not even available in the HTML at all. It...

Greetings rbarrentine, I think I understand your issue after reading the comment and investigating the dataset file that you have attached. Although I think the file you sent still lacks some of the data. I think you wanted to estimate the payout for drywall according to the person's name. And...

Greetings rbarrentine, Your comment literally has emoji in the formula. So it is quite understandable why your formula is not working. You really need to add your own file or at least an image showing what you actually want to do with the SUMIF function at all in order for us to assist you. I...

Greetings rbarrentine, Thanks a lot for sharing your problem in our forum. By looking at your formula, it seems like you want to sum values based on the condition. In this case, it seems like your arguments are in the wrong order. The only possible way to give you a solution to this problem is...

Greetings Jbuger, I mentioned that I have some confusion about this problem. And I need them to be cleared. My issue here is I do not have any raw data or sheets right now in my hand. that actually made me difficult for me to troubleshoot the issue. That's why I am giving solutions, but those...

Thanks a lot, jburgauer You absolutely need not be embarrassed with your code, this code is OK to work and you are putting a lot of effort into this. Now the thing is, I need some information and confusion cleared before I can assist you again. 1. Does the code I provided earlier worked? Or...

Greetings jburgauer, The issue that you are actually encountering right now is quite unique. Because the Edge IE can be solved very easily. But the point is, what type of data do you want to harness from Google Maps? The full code is not always accessible to normal users and the code structures...

Greetings PhilOSU2004, I understand the first two criteria you mentioned, but could not understand the third one. It would be much easier if you had provided us with the source file with some examples. Although I present a sample VBA code to a sample dataset in order to solve the problem.In my...

Greetings Bigme, Below I attached a Excel file that contains the cell that will date which is based on the spin button value. The date will start the first date of 2023 and for every spin button value increase, the date will increase by one day. You also can resize that spin button according to...

Greetings Prasad, Unfortunately, it is not possible in an Excel worksheet to fill a cell partially in three separate parts using Conditional Formatting. You only can do it using two separate sets of colors or patterns. For this, you might need VBA to resolve this. But as you mentioned, VBA is...

Greetings mFaisal, The WORKSHEETFUNCTION.IIF(iserror(statement),"Error","Clear") can not handle the division by zero error. It can only handle some specific types of errors. I prefer you to stick with the one liner solution provided above. Regards Ruabayed Razib Exceldemy Team

Greetings mFaisal, Actually, in the VBA script, the IFERROR function can't handle the runtime error like DIV/0. It will work as a normal worksheet function in the workbook, but not in the VBA script as you have shown. So that is why you are going to need the workaround. As you mentioned...

Greetings mFaisal, Here is the updated code with the file attached below. Don't forget to change the sheet name and the dataset starting row index and the column index according to your dataset. I hope this will resolve the issue.

Greetings mFaisial, Below I have given you a code that could potentially solve your problem. Sub CheckConditionAndSaveTimeValues() Dim ws As Worksheet Dim dataRange As Range Dim timeRange As Range Dim lastRow As Long Dim condition As Boolean Dim timeValues() As String...

there are numerous ways you can avoid this error. The best way may be to use the "On Error Resume Next" command right before the line that might involve an operation that can output the Error. We provided an example code with the dataset according to your scenario. Sub AvoidDivideByZero()...

Greetings mFaisal, You can use the below formula for the problem you stated, =IF(AND(B3>70%,C3="Yes",D3>=7), "Confirmed", "Not As you can see that the final verdict is showing whether the trainees are confirmed or not. based on the criteria .The excel sheet containing the formulas are...

Greetings Priya, Below, I attached a file that has the solution to the problem that you asked for. The formula that you entered is not plausible in real life and will create confusion. The corrected profit calculation is now presented in cell H2. Moreover, other cells in the worksheet is now...

Greetings, Its not actually clear what you meant. In this example you have multiple static value cell and some connected cells. Now if you changes the values of the statice cells, then other connected cell value will change. Goal seek totally a different topic in context to your given problem...

Greetings, Do you meant that the values in C12,C15 etc is not changing when you changes theother static value like the D15,D19,D20 etc?. I my case i have put the code in the Sheet and it worked perfectly, there might be one reason why your code didnot run. The reason might be that you didnot...

Greetings, Below I have given the code that will execute when you open your master file. and upon opening the file, it will take values from the porduction sheet file. Before opening the file, the worksheet will look like this, Data till 3/11/23. But we have data till 3/14/2023. After we open...