User Posts: Guria
0
Excel Optimization with Constraints (3 Case Scenarios)
0

Optimization analysis is a more complex part of goal-seeking analysis for one or more variables based on certain constraints. Even you can change the ...

0
How to Edit Text Box in Excel (2 Simple Ways)
0

In Microsoft Excel, we often use a Text Box for indicating certain instructions. It is a very handy tool with different types of elements. We can edit this ...

0
Data Validation with RegEx in Excel (With Easy Steps)
0

In Microsoft Excel, there is no inbuilt function named RegEx. Rather we have to create it manually in the workbook. This function is required to prohibit the ...

0
How to Find All Combinations of 1 Column in Excel (2 Handy Ways)
0

In mathematics, calculating combinations of a certain number of characters is a very common practice. In fact, we can count these combinations in Microsoft ...

0
How to Sort Numbers with Letter Suffix in Excel (4 Useful Methods)
0

In our regular life, we often notice numbers with suffix letters such as product code, zip code, account code, insurance numbers and lots more. But the ...

0
How to Force Recalculation with VBA in Excel
0

Formulas and calculations are the major part of Microsoft Excel. During these calculations, we often get inappropriate or false values despite giving the ...

0
How to Create Excel File from Metadata with CSV File
0

Microsoft Excel is a powerful tool to create a dynamic database. We can store the data of our device folders or browsers which is called Metadata. In this ...

0
Calculate Sum of Years Digits Depreciation with Formula in Excel
0

Depreciation is a very common term in the case of assets. In general, it is the decline of an asset over a certain period of time. There are many methods to ...

0
How to Convert Zip Code to State with VLOOKUP in Excel
0

Zip codes are defined as the postal code of certain cities or states of a country. It is used as a part of the address. Every country has its database of zip ...

0
[Fixed!] Problems with Embedded Excel Files in PowerPoint
0

When we prepare any single or set workbooks, we cannot present them with Microsoft Excel during a presentation. For this, we mostly use PowerPoint for better ...

0
How to Create Excel Sheet from Google Form (2 Useful Methods)
0

Google Form is one of the easiest applications for creating online forms. These forms are used for surveys with multiple question types. It can also be updated ...

0
How to Create Many to Many Relationship in Excel
0

When we work with multiple data strings in different worksheets, we often need to merge them. It is mostly required to get an overall view of the whole ...

0
Count Text at Start with COUNTIF & LEFT Functions in Excel
0

Counting text or characters is a very common phenomenon among regular excel users. Especially when we work with a large dataset with various criteria. In ...

0
[Fixed!] Excel VLOOKUP Function Not Calculating Automatically
0

In Excel, the VLOOKUP function is a very popular one for fetching data among large datasets. But sometimes we face difficulties when VLOOKUP does not calculate ...

0
[Fixed!] Excel Hyperlink Keeps Coming Back (5 Quick Solutions)
0

A hyperlink is a form of text that refers to a certain web address with an URL link. Microsoft Excel benefits us to auto hyperlink any text whenever we type it ...

Browsing All Comments By: Guria
  1. Hello Frank,
    Thank you for sharing your query. I am replying to you on behalf of ExcelDemy. According to your question, I assume the dataset will look like this where the product “Ice Cream” is in two rows with different dates and prices.

    Now, to solve your problem, you have to put a date in Criteria 2 that lies in between the dates you want a price from. Afterward, apply the same formula as we used earlier and it will show the accurate price.
    =INDEX($E$5:$E$16,MATCH(1,(($B$5:$B$16=G5)*($D$5:$D$16>=H5)*($C$5:$C$16<=H5)),0))

    I hope this solution will help you. Let us know your feedback.
    Thanks!

  2. Hello Tom,
    I am replying to you on behalf of ExcelDemy. It is very unfortunate to know that, you are facing such difficulties. I have gone through your queries and thought of giving the following solutions.
    1. First of all, please check this link in case you unintentionally protected your excel file through any of the methods described.
    https://www.exceldemy.com/protect-excel-sheet-from-copy-paste/
    2. When any worksheet or workbook is password protected, you cannot see them in actual letters, rather than some dots. Therefore, if you cannot unprotect the sheet with the help of this article, I am referring you to another one with some easy VBA codes to unprotect your file permanently without knowing the password.
    https://www.exceldemy.com/unprotect-all-sheets-in-excel-vba/
    3. You also mentioned that you are having trouble printing the worksheet. In this case, check this solution to solve this issue.
    https://www.exceldemy.com/excel-margins-not-printing-correctly/
    I hope the solutions will help you. Let us know your feedback.
    Thank you!

  3. Hello Mirela,
    Thank you for sharing your query. It would be really great if you can send the workbook to [email protected] as It seems quite confusing to create a dataset with the information you shared. After that, I will try to solve your problem. Hope to hear from you soon.
    Thanks!

  4. Hello Russell,
    Thank you for sharing your query. I hope the following solution will work for you.
    First, click on the Start icon and select Settings.

    Then, select Apps in the new window.

    Next, go to the Default apps section on the left panel.
    Here, check if the application for Email is selected as Mail.
    If not, then click on it and choose Mail from the list of applications.

    After this, I recommended you restart your device once. I hope it will solve your problem. Please let me know your feedback.
    Thanks!

  5. Hi Jacek,
    Thank you for sharing your query. To solve this, you can try another formula instead after copying the Code 128 Font in the C:\Windows\Fonts folder.
    First, insert this formula for the data 456987321596328 and press Enter.
    ="*"&B5&"*"

    Then, change the Font to Code 128 and the Size to 36 for creating the barcode.

    Make sure, your input data is in Text format before applying the formula.
    Moreover, VBA is not error-free. So I suggest you create a new Excel-Macro Enabled Workbook and copy-paste the VBA code to create your own barcode.
    I hope this will help you to solve your problem. Please let us know if you have other queries.
    Thanks!

  6. Hi Muniru Tahiru,
    Thank you for sharing your problem. To solve this you can go through this article. I hope it will help you.
    https://www.exceldemy.com/automatically-update-one-excel-sheet-from-another-sheet/#top_ankor
    Please let us know if you have other queries.
    Thanks!

ExcelDemy
Logo