How to use Watch Window in Excel
Often there are some cells in our worksheet… …where we have important formulas. And, those formulas help us to calculate some crucial values.In this situation, it’s really important to take an eye
Puneet
Excel Fill Justify to Merge Text from Multiple Cells to One Cell
Fill justify is a life saver option. The single core motive to use fill justify in Excel is to merge the data from multiple cells… …into a single cell.And, if you have
How to Unpivot Data in Excel using Power Query
Data in a crosstab form is good to use as a report because it’s easily understandable. But the problem occurs when you need to use it further. In this situation, you need
How to use IFERROR with VLOOKUP to Replace #N/A
While using VLOOKUP, whenever the value for which you are looking for is not there in the data you get #N/A error. In simple words, whenever VLOOKUP is not able to
How to Get First and Last Word in Excel
Often we face a situation where we need to get first and last word from a cell/text string in Excel.Let’s say… …you want to extract the first name from……a cell where
How to Count Unique Values in Excel [Formulas + VBA]
Let’s say you have a list of values where each value is entered more than once.And now…You want to count unique values from that list so that you can get
