You know the LARGE function which can find the nth largest value. Hence, if you have a series like below – And you give =LARGE(A1:A10,3), you get the answer as 18 Now, if we have a series like below Now, you give =LARGE(A1:A10,3) and now the result is 24. The reason is that large function…
Excel Quiz 19
Tips & Tricks 105 – Column Chart with Primary and Secondary Axes
You want to draw a column chart with two data series and one you want to make a primary and one you want to make secondary. Below, you have drawn a normal column chart in first chart. The second series (orange one), you have converted to secondary axis. Now, it has overlapped the first series….
Article 23 – Correcting Excel (MS Office) Errors Post Windows 10 Upgrade
Last Updated – 29-Sep-15 Arrival of Windows 10 is something which everybody waited for and users had been loving it. But few users have been experiencing problems with MS Office and particularly with Excel post upgrade to Windows 10. Since, Excel is one of the most important productivity tools which all of us use every…
Challenge 23 – Make Bar Chart to Show Performance
This time challenge is to create a bar chart like below to show the Target Planned and Target Achievement. Related Excel you can download here Salesman Performance Challenge You may post your solution in comments section. Note – Solution to this challenge will be published after 1 month i.e. on 14-Sep-15.
Article 22 – Detect corruption of MS Excel worksheet and Recover it
— This post is contributed by Priyanka Chauhan of Stellar Info. This is not an endorsement of the product on behalf of eforexcel.com — Microsoft Excel is used worldwide majorly for business purposes. It is the simplest tool which helps in maintenance of records, timelines and tasks in a table based format. Most of us…
Solution – Challenge 20 – Find Number of Friday the 13th between Two Given Dates
Below is a possible solution to the challenge – Challenge 20 – Find Number of Friday the 13th between Two Given Dates The formula for finding this would be – =SUMPRODUCT((TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Fri")*(TEXT(ROW(INDIRECT(A1&":"&A2)),"dd")="13"))
Tips & Tricks 104 – Hide a Sheet Securely
You want to hide a sheet so that nobody else can open that. This may arise in some situations like you have a dump of employee data which has sensitive information like salary, last rating, age etc. You want to keep a copy of this in your workbook but you want to refer to only…
Tips & Tricks 103 – I need to fill in A-Z or a-z very often. What to do
1. Put =CHAR(96+ROW()) in cell A1. 2. Drag down till A26 to generate a to z. 3. Put =CHAR(64+ROW()) in cell B1. 4. Drag down till B26 to generate A to Z. 5. File > Options > Advanced > Go down till you find Edit Custom Lists (You have to go down till bottom) and…