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
Puneet
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
How to Get End of the Month Date in Excel
Sometimes we need to get an end of the month date to use as a completion date, due date, as a target date or sometimes we need it to calculate
