Sometimes the data is spread over multiple worksheets and the requirement is to consolidate them in to a single worksheet, usually either we copy and paste data individually for each sheet or consolidate option of Ms-Excel can be used but
We have been using Sort function for so long in our work but still one of the most unexplored feature of this function is that we can sort data row wise also. This could be useful in some cases, where
When we paste data on filtered rows it always past it on both visible and hidden rows. And if you are doing this for a huge set of data then I am sure you must be pasting it manually and
Ever came across a situation where you need to apply Vlookup on duplicate lookup values?? Like the one below…
Note:- Download the Exercise workbook from here.
Here we have course ID repeating in “Lookup Table”. If we
How to Prevent Duplicate values through Data Validation
In this post we will see how we can prevent/stop any range to accept any duplicate values. We all know the power of Data Validation. We can do a lot of
As most of us already use drop down lists through data validation but sometimes it makes much more sense to create a dependent drop down lists e.g. you create a drop down list in cell A1 and as you choose
How To Handle Missing Data In Excel Charts !!!
Ever come across a situation when you have some blanks in data for which you need to create a chart for? Or have any hidden rows or columns in the
If we want to count the number of working days in a given period excluding weekly off (optional) and any other holidays (optional), the best way to do it in Excel is through using NETWORKDAYS.INTL. Most of us usually apply