The best part of conditional formatting is you can use formulas in it.And, it has a very simple [...]
About PuneetThis author has not yet filled in any details.
So far Puneet has created 141 blog entries.
VLOOKUP is one of the most popular Excel functions and there’s no doubt about it.You know this from [...]
I'm sure you want to make VLOOKUP more powerful.Well, using wildcards with VLOOKUP can do this for you.It [...]
Last week, I got an email from one of my subscribers with a question.Hey Puneet, how many methods [...]
In Excel, when we normally combine text from different cells using CONCATENATE.But sometimes while doing this we need [...]
How to Calculate Ratio in Excel A ratio is one of the common methods to compare two [...]