User Posts: Bishawajit Chakraborty
When you develop, download, or upload a Microsoft Excel workbook, it may contain information that you do not want to make public online. The formal name for ...
In this article, we will demonstrate 3 handy ways to find the largest lookup value using the combination of the VLOOKUP function with other functions in Excel. ...
Using this function, it is possible to analyze text, values, and even errors. It extends beyond simply determining whether two things are equal and then giving ...
After you create a pivot table, you must use the change data source command to update or refresh the data in it. However, it is time-consuming and inconvenient ...
If all the data were flawless, absolute, and comprehensive, that would be good. Excel, however, provides us with some helpful tools to communicate margins of ...
You can employ the Excel database functions to help you when using an Excel dataset. Sometimes, you may need to find the variance due to some specific ...
Tracking error is one of the most crucial metrics for evaluating a portfolio's performance and a portfolio manager's potential for outperforming the market or ...
SmartArt mixes graphic and textual content to give information a more aesthetically pleasing presentation. You can make fantastic SmartArt with the help of ...
An imaginary coefficient with a real coefficient makes up a complex number. Real and imaginary coefficients can be transformed into complex numbers of the type ...
Excel charts are a fantastic tool for displaying data. Excel charts can easily represent complex data and provide users with useful information. The majority ...
Users frequently want to click a button and choose a date. The same holds true for Microsoft Excel programmers. Making use of InputBox and MessageBox while ...
When the order of the arrangements is concerned, a permutation is a mathematical technique that establishes the total number of possible arrangements in a ...
Definitely, one of the most popular software programs utilized globally and in many fields is Microsoft Excel. Users can access web pages and extract data from ...
You have come to the right place if you're looking for instructions on how to encode data in Excel. Despite this being a necessity, there is currently no ...
When working with large data sets in Microsoft Excel, you may need to remove specific rows from the worksheet because of security purposes. This article will ...
- 1
- 2
- 3
- …
- 6
- Next Page »
Thank you so much Sharath for your response. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
Regards,
Bishawajit Chakraborty.
Thank you BRIAN for your wonderful question
If you want to import stock prices on a weekly basis, you can visit this website link, from which we scraped our live data in accordance with this article.
Then, click on the Frequency option and select Weekly for your desired frequency.
Finally, apply the rest procedures mentioned in the article. I hope this may solve your issue.
Bishawajit, on behalf of ExcelDemy
Thank you, Fred, for your wonderful question.
Firstly, go to the Home tab.
You can keep the decimal places of any number at any place by using the Increase Decimal and the Decrease Decimal icons here.
Bishawajit, on behalf of ExcelDemy
Thank you, SALWA for your wonderful question.
First off, you cannot change the time for a scheduled email; however, you can add the remaining date in the email using the VBA code. When you apply the VBA code, the emails will pop up for sending. And on the Outlook email section, you can customize emails with scheduled time
Then, using your Outlook account, you can set it up for a scheduled email. I hope this may solve your issue.
Bishawajit, on behalf of ExcelDemy
Thank you, JOHN SCURAS, for your comment.
You can use the below formula to determine your commission of the model.
=IF(H36>C33,SUMPRODUCT(–(H36>$C$33:$C$56),(H36-$C$33:$C$56),$D$33:$D$56)+C33*E33,C33*E33)
Here, H36 is the sales amount, C33 is your first Deal Size Range (High), C33:C56 is all values for Deal Size Range (High) column, D33:D56 is all values from the % incremental commission column, and E33 is the first value of the incremental commission (5%).
Best Regards,
Bishwajit
Team ExcelDemy
Thank you so much JOHN JOYCE for your comment. To set all the columns into text, you can follow the below steps accordingly.
After changing the format save the file and re-open it to check whether the data shows in the proper format.
Best Regards,
Bishwajit
Team ExcelDemy
Greetings AND74,
Thanks for noticing the error.
It will be OR(C5QUARTILE($C$5:$C$14,3)+1.5*$D$16) instead of OR(C5QUARTILE($C$5:$C$14,1)+1.5*$D$16).
We will make the corrections shortly.
Best Regards,
Bishwajit
Team ExcelDemy
Thank you, Edward Vinieratos, for your comment. According to your formula, your data seems quite large. It is hard to identify where the error lies. Can you please kindly share your excel file with us? We will create another Excel file with your desired result. We will reply to you back as soon as possible. Email Address: [email protected].
Thank you Edijs for your wonderful question. To edit the cell range follow these steps:
Firstly, enable the Microsoft Forms 2.0.
Secondly, type this code on to sheet 2.
Thirdly, type change the code from Module 1.
This should solve your problem. You can see the output from the following animated image.
If you have any further question, please let us know.
Regards
Bishawajit, on behalf of ExcelDemy
Thank you, Brian for the comment. You can use the following code to insert timestamp when value from a specific row change:
The following shows it working.
Now, for your second part of the comment. You can use this code for multiple rows:
The animated image shows it is working for two rows.
Regards
Bishawajit, on behalf of ExcelDemy
Thank you Prachi Davade for your wonderful question. You can change the
to
This will do what you desire. If you have further queries, let us know.
Regards
Bishawajit, on behalf of ExcelDemy
Thank you, Madan, for your comment. In our Excel file, this formula is working. Can you please share your excel file with us? Email Address: [email protected]. We will try to solve your problem as soon as possible.
Thank you so much, Peter, for your comment.
You will find your solution in the below steps. Please follow the steps accordingly.
Steps:








• Firstly, go to the Data tab.
• And, select the group option.
• Now, you will see here the plus (+) sign.
• Here, we have grouped the 5th, 6th, and 7th rows.
• Then, go to the Review tab.
• And, select the Allow Edit Ranges option.
• After that, choose the ranges.
• And, type the password and click OK.
• Retype the password and click OK.
• Now remove this window.
• Firstly, go to the Review tab.
• Secondly, select the Protect Sheet option.
• Now, write your password.
• And, click OK.
• Then, retype your password and click OK.
• So, if you click on the plus (+) sign, it will show you the given result you want.
Hello Rash,
Thank you for your comment. If you want to send a table within the email body for any range, then you have to create a table in any worksheet. For this, you will follow our Method No.3 where we have used a VBA code to send an active sheet within the email body. Firstly, you can create a table in this active sheet and send this sheet with your table within the email body. Can you please share your Excel file with us? We will customize the file according to your requirements. Email address [email protected].
Regards,
Bishawajit Chakraborty (Exceldemy Team)
Thank you, Dhroov, for your comment. In our Excel file, this formula is working. Can you please share your excel file with us? Email Address: [email protected]. We will try to solve your problem as soon as possible.