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
Suppose you apply a formula in a cell and you get an error, the reason could be anything but the problem lies where you don’t want to share a report which contains errors. With the use of IFERROR we can
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