Search results

Hello HarvestChurch, First, I would like to apologize for the late response. I am really delighted to know the previous reply was useful. For the suggested VBA method, it would be really cumbersome to implement for the same scenario. However, I can provide a VBA code that is triggered when you...

Hello bigMe, Glad to hear the code was useful. If you have any further questions or need more assistance, feel free to ask. The community is always here to help and support each other. Best Regards.

Hello HarvestChurch, Welcome to our website! I understand you wish to format the tasks using Conditional Formatting in your Eisenhower Matrix. Though I think using VBA would be the better option. But it is also possible through Conditional Formatting. I assume you already have added the Data...

Hello Bigme, Glad we could help with our suggestion to use the AGGREGATE function to sum the total with hidden rows/numbers in the previous reply. I understand you wish to hide rows based on a condition through VBA and perform the in-built AGGREGATE function. Assuming the condition is: Hide...

Hello Tijav, Yes, you can utilize the following formula that can help you distribute the cost equally among the selected range of cells with varying pricing items in number each month. The steps to do it are: Initially, input the formula in C2 and press Enter. =IF(COUNTBLANK(B2)=0...

Hello Claire, Thank you for the detailed explanation of the problem. I understand you wish to apply another condition with 2 criteria. To create this combination of conditions, you can use a formula that combines the two conditions using the AND function. Follow the below instructions...

Hello ASD, Thank you for the detailed explanation of the problem. Though it would be more helpful if you could share a demo dataset for a closer look. Based on your explanation, it seems like you're comparing two lists of consumer IDs to verify payments, and you're using the VLOOKUP function...

Hello Faisal, I understand that you have an excel file on your google drive and wish to extract data from that file and store it in a local excel file on your desktop. Fortunately, this is all possible with a simple trick. Follow the below steps carefully to do so. Firstly, open your file on...