User Posts: Kawser
VLOOKUP is one of the most powerful and top used functions in Excel. Using IF logical function with VLOOKUP makes the formulas more powerful. In this ...
READ MORE +
Getting data from another spreadsheet based on a cell value might be quite useful for some projects and reports. In this short article, I will show using Excel ...
READ MORE +
In this article, I will show you how to remove the pivot table but keep the pivot table data. The pivot table is very important when we want to analyze or ...
READ MORE +
In this article, I will show you several tricks that you can use to merge two cells in Excel without losing data. Using Excel’s Merge & Center command, you ...
READ MORE +
Printing in an efficient way creates a lot of positive impacts on the mother environment and your office balance sheet. So, I always inspire people to print in ...
READ MORE +![Using Excel to remove duplicate rows based on two columns [4 ways]](https://www.exceldemy.com/wp-content/uploads/thumbs_dir/Remove-Duplicate-Rows-8-1tx7brby2y2umwdobibeh03aj4ytmaxp5umd9n2e6lqc.png)
Removing duplicates is a very important part of any kind of data analysis. And your duplicate occurring can be quite different from others. In this article, ...
READ MORE +
If you do not like without your permission no one can edit or update your Excel file, you can make your Excel file read-only. If you don't know how to make an ...
READ MORE +
In this article, I will show you how you can use Pivot Table data in Excel formulas. No data analyst can think a day without using Pivot Table in their day ...
READ MORE +
So, you're looking for free online Excel course with certificates. You're at the right place. On this page, I've listed 40+ free Excel courses (online ...
READ MORE +![Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!](https://www.exceldemy.com/wp-content/uploads/thumbs_dir/Creating-and-Editing-Excel-Comments-to-Cells-–-An-Ultimate-Guide-1ss3pij4zzvtla3x5kwj3hrplayw24dap72o8mvtpabo.png)
Today’s post will be concerned with comments. We will be seeing how and when to use them. So let's get started. Firstly, you normally insert a comment to a ...
READ MORE +
In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook. It has ...
READ MORE +
Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our archives ...
READ MORE +
With this post, we shall be starting our Excel Table series. Today’s post, in particular, will give you an overview of the topic at hand and walk you through ...
READ MORE +
When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the range. ...
READ MORE +
Have you ever heard or seen the terms big data, business intelligence and Power BI being mentioned in analyst’s reports and financial newspapers? These days ...
READ MORE +Browsing All Comments By: Kawser
ExcelDemy is a place where you can learn Excel, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide Excel solutions to your business problems.
ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. I earn a small commission if you buy any products using my affiliate links to Amazon.
It’s my pleasure Rick. Nice to see you here and thanks for commenting!
Aziz Bro, thanks for your comments. Excel has extended its power more in recent times making Excel to work with Microsoft’s Power BI tools. I shall focus on them within very short time. Keep in touch. Thanks again.
Mohammed Hussain,
Thanks for the comments 🙂
Thanks for notifying me. It was a technical mistake. I’ve uploaded them and you can download now. Thanks.
Hi Mark,
Use the following formula instead of the formula you’re using.
=DATEDIF($B$1,$B$2,”Y”)& ” years, “&DATEDIF($B$1,$B$2,”YM”)& ” months, “&ROUNDDOWN(DATEDIF($B$1,$B$2,”MD”)/7,0)&” Weeks, and “&DATEDIF($B$1,$B$2,”MD”)-ROUNDDOWN(DATEDIF($B$1,$B$2,”MD”)/7,0)*7&” Days.”
Regards
Kawser
Thanks for your feedback 🙂
Thanks a lot for the feedback. I shall input this method when I will update this article later.
You’re welcome.
Best regards
Thanks for your valuable comment. Unfortunately, right now I don’t have any dashboard like that. Maybe later.
Thanks and regards
Thanks, Mittal!
Thank you so much for your feedback.
Best regards
Thanks for your feedback.
Thank you for your valuable feedback. It’s something 🙂
Best regards
Yes, Robert!
Thanks for the feedback.
Thanks for your valuable feedback.
You’re most welcome, Sola.
Thanks for your feedback.
Thanks for your feedback. Glad to know that it helps you.
Thanks, Melinda!
Yes, it was a typo and I have corrected it.
Best regards
Kawser
Thanks, Mark.
Hi Helen,
Thanks for the feedback.
And I will work with the click-baits to make it more user-friendly.
Thanks and regards
Thank you for your feedback, Anirudh!
Best regards
You’re welcome.
Ram,
I have a list of Excel books that is good for learning Excel from the beginning. Please visit this page: https://www.exceldemy.com/best-excel-training-books/
The best is obviously the Excel Bible Series. You will get the link on the page. If you talk about Video Channel, it is tough to find one as most of them don’t start from the beginning. But if you search for a topic, there are several. One of the best is ExcelIsFun YouTube channel. I hope it helps.
Best regards
Kawser
Hi David,
Check our your email.
Thanks.
Hi Mike,
Check out your email.
Thanks.
It is sent. Check out your email.
Thanks, Emil!
You have to use VBA or you can use Power Query.
You are welcome.
Hi Daniel,
Thanks for your feedback.
Yes. INDEX and MATCH combo work in a more versatile way than the VLOOKUP function. I did not use Index Match because I wanted to show all the examples with VLOOKUP and IF Functions.
Keep in touch.
Best regards
Kawser
Thanks for your feedback, Uche Uche.
Feeling happy to know that you found the articles helpful.
Best regards
Kawser Ahmed
I will check out this code. Thanks for the input.
Thanks for your feedback, George!
Please check your email. I have sent the file. Thanks and sorry for the inconvenience.
You can collect it from our resource page. The resource page is shared with every subscriber, every day.
Best regards
Kawser Ahmed
Glad to know that it was helpful.
You’re welcome 🙂
You are welcome, Chandrasekhar! Glad to hear that our tips help you.
Best regards
I will update you.
Best regards
Kawser
Hi Stanley,
Thanks for the comments. Glad to hear that it is helpful. Yes. You can share it with an online class with an attribution to our blog.
Best regards
James, thanks for your feedback.
Glad to hear that it was useful for you.
Regards
Hi Anatoly,
We have written a detailed guide on solving equations using Excel. You will get the guide here: https://www.exceldemy.com/solving-equations-in-excel/
If you have some specific equation, let us know via email.
Thanks and regards.
Hi Moataz,
Thanks for the feedback on our blog.
Actually, this is not a big deal. The concepts are same with both Excel 2013 and Excel 2016. Most of the variations/updates occur with the Excel features, not in VBA. Just start with what most suit you.
I hope this reply helps you.
Thanks and regards
Thanks for asking. It was creating more indexed pages in Google that was bad for us. What you can do is: just you can copy the whole article and paste into a word document and then convert it into a PDF file. There is little chance of getting back of that button.
Best regards
That is really a good percentage of reduction. Thanks for the feedback, Abraham.
Hi Ajeet,
Then you can download it from the Excel Resources Page that you get in every email I send.
Thanks.
Hi Ahmad,
You’re welcome. Glad our blog posts help you master Excel topics.
I have updated this part. For your clarification: the condition 1 must be fulfilled to be eligible to take the thesis work/project. Of the last conditions, students must fulfill one condition. I hope this makes things clear to you.
Best regards
Kawser
Thanks. Glad to know that you found it useful.
Thanks, Farhana for the feedback.
Thanks for your feedback, Ven!
Thanks, Menon for your valuable feedback.
Mike,
Thanks for your feedback 🙂
Kind regards
Nope, Jan. You’re absolutely right. Excel can be used as a database when your database is not heavy and need a small load of query on it.
Please check your email.
Hi John,
Sometimes discounts expire. Now the discounts are available. Thanks for your feedback.
Thanks for your feedback. Best wishes with your new journey 🙂 Excel, Word, and PPT are three most powerful office tools. I’m sure, you will enjoy your journey 🙂
Please check your mail.
Hi Bob,
Did you download the Excel file before you follow me? Please do so. I’ve explained the whole process with two real time examples. If you can create these two examples in the Excel file, I hope you will be able to understand the whole system.
Best regards
Kawser
Check out trying. I never tried. If you face any problem, let us know 🙂
Thanks, Subbu!
Glad to know that it helps. The file is at the end of the article. Just click and download.
Thanks for your feedback 🙂
Thanks, Piotr! Glad to know it helps.
Syed,
Sometimes when the formula is posted in WordPress platform, it might be changed. Please, download the working file and check the formula there.
Thanks for the feedback, Prabhudeva!
Roger, thanks a lot. I did not notify the issue. It’s a crucial problem. I am working on it.
Yes, when a number or date is placed in a cell in Text format, you cannot calculate with them.
Roger, this option (make PDF of the blog posts) is on my plan. Will execute in shortest possible time.
Best regards and thanks for the comments.
Roger, please check your email.
Thanks.
Please check your email, Kaz!
Thanks.
Yes. Corrected.
Thanks, Luke for the tips.
It’s a good idea, Rahul. I will think about it soon.
Best regards
Kawser
Spoo,
I would recommend starting with Excel 2016 (or 2013) if you’re just starting. It’s better to be updated with time.
Yes, some are still using Excel 2003 but that is not a good idea. They are missing a lot of new features Microsoft has added to this superb tool later.
Regards
Please check your email, Sohail!
I will pass your request to the author, Jagadeesh!
Glad to know it helped you!
Please check the email 🙂
Hey Tricia,
I checked several times the link. There is no problem with the link 🙂 This is not a direct download link. You have to subscribe to get the cheat sheet. I hope you should not be embarrassed with the shared link.
Best regards
Kawser
It’s sent, check your email.
Thanks, Mohan!
Raja, any working file on that?
Thank you, Jaypogi!
Many thanks, Scott!
Thanks, Sam! I will reach it to Zhiping 🙂
Check your email please, Smith!
Armen, files are uploaded. Please let me know whether the concept is clear to you or not!
The working files are uploaded. Thanks!
Jack, I have notified it to the writer. She will answer soon 🙂
If cell A1 holds your string “BCD” and you want to show “AAAAAAABCD” in cell B1, input this formula in cell B1: =REPT(“A”, 10-LEN(A1))&A1.
To solve this problem, you don’t have to use any looping. Or, do you have some other requirement for this problem? Let me know.
Best regards.
Cindy,
Millions of thanks for correcting me. It was a grand mistake. Sorry for that. You can buy the course now for just $10 using the above link.
Best regards
Thanks Fina for sharing.
Regards
Please, check your email.
Regards
Please check your email.
Cherie,
Check your email, please.
Regards
Borb,
I tried to reach you to your email address but it is showing the mail cannot be reached.
How can I help you?
Regards
Kawser
Kateryna,
Thanks for your kind words. Glad to know that it helps.
You will get empty cells if no data is available for the filtering. What criteria did you use to filter data in intervals?
Waleed,
Can you upload the working files of your problems? At least a sample file? If possible send an email to this address kawser@exceldemy.com
You can do that Ahmed. Thank you.
Regards
Baber,
I have sent you an email with instructions. Please check. I hope the email solves the problem.
Regards
Thanks for the input, Jomili.
Yes, the formulas are identical as every criterion in the Criteria range is unique. I am going to add the note there 🙂
Mike, you did a phenomenal job! Thinking in that way, awesome and the alternative!; Hats Off!
First Rate Work, Kadeo! Take my bow 😀
Yes, Menon! It’s a nice solution and more generic!
Thanks for the input, specially for the VBA part!
Cool 😀
Great Answer!
Please check your mail, Lilly.
Please check the mailbox. I have sent you an email with the direct download link of the resources.
Please check the mailbox. I have sent you an email with the direct download link of the resources.
Please check your mail.
Thanks and regards
Hi Gina,
Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page.
Best regards
Kawser
Hello Rush,
Thanks for your feedback 🙂
If you are an email subscriber of my blog, then you would have access to all my data sets (workbooks or anything else) that I use to make the blog posts.
Regards
Kawser Ahmed
Hi Roger,
Thanks for your feedback. Nice to meet an Excel Pivot Table ninja 🙂 If you like you can share your ninja skills with my audience.
Regards
Hi Roger,
Please check your inbox. Sorry for the inconvenience you are facing.
Thanks and regards.
Thanks Jan for your feedback.
Thanks Orlando for updating me 🙂
Regards
Kawser
Vikas,
Glad to know you liked it. Thanks for your feedback.
Regards
Puneet, thanks for the comment. I like your presentation in your blog.
Wishing you the best output in year 2016.
OZ thanks for your feedback. I am going to write these types of posts like a series. Your comments made me more inspired 🙂
Praveen,
Would you please mail me the database and other resources using the mail in the contact me page?
Thanks.
It’s my pleasure Bob. Thanks for sharing.
Narendra, if you feel any way I can update my website, please let me know.
Thanks and regards.
Shivaji,
Right now I have no book on Microsoft Access. But just subscribe my Email list using the below link, you will get two books on Excel: 1200+ Macro Examples E-Book, 220+ Excel Keyboard Shortcuts E-Book and other Excel resources.
http://www.eepurl.com/bqFItv
Shivaji,
It is my achievement when a person says me that I helped him/her in some way. Thanks. Keep in touch.
Glad to hear that my website is helping you in a way.
It’s my pleasure Mohammed Hussain. Keep in touch 🙂
In the Download Section, you will get the Workbook: production-model-scenarios.xlsx.
Rajesh,
If you’ve given names to the changing cells and result cells, the table uses these names; otherwise, it lists the cell references. Just use some names for the cell references B13, C13, D13 and B15 in the Sheet1 Worksheet in the provided Workbook. Then create the Summary Report again. You will get the result cells using some names.
It’s my pleasure you liked the article. Thanks for the nice comment. Best regards.