Kawser Ahmed

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.

It’s my pleasure Bob. Thanks for sharing.

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

We shall try to help. Thanks.

Glad to know that the article added some value to your work, Sadie!

Hi,
Download the files from this link: https://www.exceldemy.com/microsoft-excel-formulas-functions-cheat-sheet/#Download_Excel_Formulas_Cheat_Sheet_PDF
Thanks.

Hi Puspesh,
Download the files (PDF and Excel Files) from this link: https://www.exceldemy.com/microsoft-excel-formulas-functions-cheat-sheet/#Download_Excel_Formulas_Cheat_Sheet_PDF
Thanks.

Hi Blump,
We do use Microsoft 365 version to make our documents. If you use older versions of Excel, you may not find it.
By the way, thanks for your feedback.
Thanks.

Thanks for your feedback, Bhat.
Best regards

Thanks for your feedback, Annie.

Thanks for referring, I will check.

You just download it from the link, just click on the download links. Thanks.

I have to check, Glen. Thanks.

Thanks for your feedback!

This is not completely automatic, Lea!

Hi Alexa,
Thanks for your feedback.
Best regards

Send your problem to this email: [email protected]

No problem. Send the file to this email: [email protected]
Thanks.

I will gladly help if I am able. [email protected] Thanks.

OK, Nancy, I am keeping at our note, we shall develop a template as you require. Thanks for your feedback.

The best way is, please send the sheet to me at [email protected]

Best regards, Mario!

Hi Kaitlin,
Can you please share your Excel sheet with me? Here is the email: [email protected]. Thanks.

Hi Craig!
Just use the MAX function in the first column, you will get the largest number from the column.
Best regards

Hi Sherry,
If you can send us the resources, we can help you. Thanks.

Hi Justin,
Thanks for notifying this. I will check and update the article.
Regards

If you’ve some specific problem, let us know via email, we shall try to make a blog post with your problem.

Hi Denny,
I am using Microsoft 365 (Home) and it is working on my side perfectly. Please try again.
Thanks.

Not yet, Walt!
But we shall start making a lot of templates in the coming months. If you need any, you can let us know.

Hi Ahmed,
I am keeping a note of your problem, hope we shall be able to make a solution to this.
Thanks.

Hi James,
Thanks for your input.
I am taking note of your problem, and we shall make templates based on your criteria.
Thanks and regards
Kawser Ahmed

Hi Greg,
That is really good input from you. Hope your piece of code will help people who are in trouble. Cheers!
Best regards

Thanks.

Thanks, Uche.

Hi Kkrao,
I understand your thought.
It is possible for small numbers to count the top ones, but if you have good numbers in a list, you might need an automatic process. And sometimes, you might need the output to feed a system’s input, so I hope you get my point for making a formula for this.
Thanks.

Hi Manzis,
Please check out your email.
Thanks.

Hi Tony,
I will check your formula.
Thanks.

I have sent the pdf link to your email address. Thanks.

A great pleasure for me. Thank you.

Thanks, Christina for your feedback. Glad to know that it helped you someway.

Hi Vishnu,
Thanks for your nice words.
Best regards

FERREIRA, Thanks for your feedback!

Thanks, Kelly for your feedback. Glad to hear that it helped you.
Best regards

Thanks for your input 🙂

Nice to hear that you found this article helpful. Thanks for the feedback!
Best regards

Hello Wasim,
I am keeping this on my to-do list. Will try to give you a solution of your problem.
Thanks.

Glad to know that this was helpful to you 🙂
Best regards

You can copy the article and paste in a word file and then use it personally. Thanks.

You’re most welcome! Thanks for your feedback, Anthony!

You’re welcome, Florano!

Nice, Roger. I am glad to know that the formula helped you 🙂

Thanks Chamila for your feedback!

You’re most welcome, Dennis!
Thanks for the nice words.
Best regards
Kawser Ahmed

Maybe a little bit tough for the complete layman. I shall change my Phrase then 🙂

It is sent. Thank you.

Thanks for your Prayer, Shakeel!
Best regards
Kawser

Thanks for your feedback!

I am keeping your note. Thanks, Jaime for your feedback.
Best regards
Kawser Ahmed

Thanks for your valuable input.
Best regards
Kawser Ahmed

Thank you so much for your input, Wayne! Hope this input helps my readers 🙂
Best regards
Kawser Ahmed

Nice to hear that it helped you. Thanks and regards.

Thanks, Sarabjeet Singh, for your feedback!

Thanks for your feedback 🙂

Thanks for your feedback 🙂

Thanks, Surya!

I am sorry, I am not available for freelance.
But you can contact our partner here: https://www.exceldemy.com/consulting-services/
Thanks.

You can use the DATEDIF Function without any problem.
Thanks.

Thanks a lot for your feedback. I will make plans to correct them. Best regards

Thanks, Ghosh for your feedback.

Glad to know that you liked this article.
Thanks for the feedback.

Not right now. I will update when I will have one. Or if you have any specifications, let me know. I will make one for you.
Thanks and regards
Kawser

Please, download the working file (it’s free) to see if anything is missing in this article.
Thanks.

Thanks for your feedback 🙂

You’re welcome.
Best regards

Thanks, Mittal!

Thanks for your feedback.

Yes, Robert!
Thanks for the feedback.

You’re most welcome, Sola.
Thanks for your feedback.

Thanks, Melinda!
Yes, it was a typo and I have corrected it.
Best regards
Kawser

Hi Helen,
Thanks for the feedback.
And I will work with the click-baits to make it more user-friendly.
Thanks and regards

You’re welcome.

Hi David,
Check our your email.
Thanks.

It is sent. Check out your email.

You have to use VBA or you can use Power Query.

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

I will check out this code. Thanks for the input.

Please check your email. I have sent the file. Thanks and sorry for the inconvenience.

Glad to know that it was helpful.
You’re welcome 🙂

I will update you.
Best regards
Kawser

James, thanks for your feedback.
Glad to hear that it was useful for you.
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

That is really a good percentage of reduction. Thanks for the feedback, Abraham.

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, Farhana for the feedback.

Thanks, Menon for your valuable feedback.

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.

Hi John,
Sometimes discounts expire. Now the discounts are available. Thanks for your feedback.

Please check your mail.

Check out trying. I never tried. If you face any problem, let us know 🙂

Glad to know that it helps. The file is at the end of the article. Just click and download.

Thanks, Piotr! Glad to know it helps.

Thanks for the feedback, Prabhudeva!

Yes, when a number or date is placed in a cell in Text format, you cannot calculate with them.

Roger, please check your email.
Thanks.

Yes. Corrected.
Thanks, Luke for the tips.

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

I will pass your request to the author, Jagadeesh!
Glad to know it helped you!

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

Thanks, Mohan!

Thank you, Jaypogi!

Thanks, Sam! I will reach it to Zhiping 🙂

Armen, files are uploaded. Please let me know whether the concept is clear to you or not!

Jack, I have notified it to the writer. She will answer soon 🙂

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

Please, check your email.
Regards

Cherie,
Check your email, please.
Regards

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?

You can do that Ahmed. Thank you.
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 🙂

First Rate Work, Kadeo! Take my bow 😀

Thanks for the input, specially for the VBA part!

Great Answer!

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

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,
Please check your inbox. Sorry for the inconvenience you are facing.
Thanks and regards.

Thanks Orlando for updating me 🙂
Regards
Kawser

Puneet, thanks for the comment. I like your presentation in your blog.
Wishing you the best output in year 2016.

Praveen,
Would you please mail me the database and other resources using the mail in the contact me page?
Thanks.

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

Glad to hear that my website is helping you in a way.
It’s my pleasure Mohammed Hussain. Keep in touch 🙂

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.