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 stuff through Data validation e.g. we can restrict cells to accept any number of any …
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 any item from that list, the items of the other drop down list in cell …
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 data? We know that it is very logical how excel create a chart in this …
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 NETWORKDAYS function to count the number of working days in a given period, but this …