How to Count Cells with Text in Excel
Last week one of my readers asked me for a simple formula which he can use to count cells with text. Actually, he was trying to figure out which is the
Puneet
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
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
How to Create a Step Chart in Excel
A step chart is a perfect chart……if you want to show the changes…happened at irregular intervals.And that’s why it’s a part our advanced charts list.It can help you to present