It happens sometimes… …when we need to lookup for a value from a table… …according to the row heading and… …column heading.It happens sometimes when we need to lookup for a value from
Everyone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level.
In Excel, we can’t simply use default MAX function with a condition……(unless you are using Microsoft Office 365).But the thing is…If want to get maximum value from a range using
Compound interest is one of the most important financial calculations which most of us often use. And, it’s must to learn to calculate it in Excel.But before you do that……you need
I have a strong reason for you to use a dynamic chart range. It happens sometimes that you create a chart and at the time when you update it… …you have to
Sometimes working with data is not that easy, sometimes we face complex problems. Let say, you want to search for the text “Delhi” from the data. But, in that data, you