Recent content by Rubayed Razib

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