Search results

I am afraid this question seems unclear. Can you share your workbook and explain it a bit more thoroughly? Thank you.

For Q3, Use the given formula: =IF(A2 < 50, 0, IF(A2 <= 80, 5, 10)) As a result, we find the each corresponding values as you assigned. Let me know if it works. I am attaching the desired workbook. Regards, Yousuf Shovon

Hi Sharyn, Welcome to ExcelDemy Forum! Thank you for sharing your concerns. After going through your post, I am afraid I am not able to understand some points thoroughly. For instance, the table data you mentioned in Q1, are they in the same cell or different cells? However, I created 2...

Hello Dan Carle, Welcome to ExcelDemy Forum! Thank you for posting. I understand you want to add a formula that it returns the same value across multiple cells. Again, you have mentioned some conditions or rules for the data setup. Unfortunately, I don't see a valid Rule or Condition you are...

Hello BigMe, Glad to hear from you again. Thank you for the thorough explanation of the issue. To answer your question, the below VBA function will compare texts between 2 cells ignoring such cases. Here is the VBA code: Function FindMatch(cell1 As Range, cell2 As Range) As String...

Hello Anthony, Welcome to ExcelDemy Forum! Thank you for your question. I understand you are facing the SORT and Null issues. I have found a way to have a formula return a blank cell instead of a null cell using SORT and IF functions. I have tried to create a dataset based on your...

Hello Jasper, Thank you for your feedback. I am glad to hear that you have made this work on your own. Feel free to reach out to us if you have any issues or problems related to Excel. Regards, Yousuf Shovon

Hello JPNHT1983, Welcome to our ExcelDemy Forum! Thank you for your post. I understand you wish to set a Conditional Formatting rule for given keywords in the range A1:EX1 in Excel. We will give you 2 rules that will format the cells with the given keywords. We will use the SEARCH and OR...

Hello Jasper, Welcome to our ExcelDemy Forum! I checked out your shared file and the formula appears to calculate different values based on the conditions related to retirement status in B2 and the value in C2. However, the conditions and syntax in the formula are incorrect. That's why it...

Hello Tam, Glad to hear from you again. Thanks for your feedback. It is nice to know you are interested in Excel VBA. If you often find yourself, doing repetitive tasks over and over again in Excel and wishing that somehow, someway these tasks could be automated, Excel VBA is the right choice...

Hello Smoberly, Welcome to the ExcelDemy forum. Thanks for the detailed explanation of the issue. I understand you wanted to customize your cell format. Which would be easy using Excel Formula or features. The below article has 17 methods to do so: How to Custom Format Cells in Excel However...

Hello VasimKhan, Welcome to ExcelDemy Forum! I understand you want a formula to get week wise supervisor level count of attendance and leave it in the yellow highlighted cells. Reviewing your dataset, I think we can create a formula. But, you did not specify how dynamic you want this to be...

Hello TAM, Welcome to ExcelDemy Forum! I understand you wish to get the column headers of the latest value into the given yellow column A. This procedure could be easier with Excel VBA than with formulas. Here are the steps to find the header names of the last values: First, go to Developer...

Hello Craige, Welcome to ExcelDemy Forum! To answer your question, Conditional Formatting is a better choice than VBA. Though in this case, I would apply Conditional Formatting in VBA by defining criteria for each conditional format. Here is the VBA code: Sub ApplyConditionalFormatting()...

Hello Bigme, Thank you for your feedback. Formatting data into Excel Tables can be troublesome with VBA. Instead, let's try an easier way. I have modified the VBA code that takes sections of data from the source worksheet, pastes them into the template worksheet, saves each section as a...

Hello Faisal, To count cells in row 7 where the Fill Color is Yellow, you can define a custom function CountCellsByColor in VBA. The purpose of this function will be to count the number of cells in the specified range rng that have the same fill color as the cell referenced in color. Also, to...

Hello Bigme, Thank you for your response. And Yes, it is necessary to convert the data to Excel table format first to accurately define them. Here is the way to do so: Steps: First, select the data you want to define as a table >> go to Home >> Format as Table >> choose any table format...

Hello Bigme, You can copy each table from Source sheet, paste them in Template separately and finally print them using Excel VBA. However, it's necessary to format the Source sheet data into Table formats. This is because you have empty cells in your table and this would be confusing for Excel...

Hello Krp, Welcome to ExcelDemy forum. I understand you wish to copy a range from a protected worksheet with a locked header row and paste it to an email body as an HTML table. Fortunately, I was able to modify the code you provided and fix it. The algorithm: Temporarily unprotect the sheet...

Hello Faisal, Thanks again for your concern. Excel provides no in-built event to trigger the module when you unprotect the workbook. Workbook_WindowDeactivate event is the closest we have that triggers an event when a window or dialog box is closed, but it also does not detect the closing of...