Everybody is quite aware about Autofill. There are various ways to Autofill. Refer to following article for Autofill – Article 7 – Generate a Sequence of Numbers Now, apply a filter on your range and all the techniques fail. If you drag, all cells are filled with 1 and no other techniques also work. The…
Excel Quiz 20
Article 24 – Convert a Number to a Month Name
Use below formula to generate named 3 lettered month like Jan, Feb….Dec =TEXT(A1*30,"mmm") Replace "mmm" with "mmmm" to generate full name of the month like January, February….December in any of the formulas in this post.
Challenge 24 – Sum a Range Conditionally where Range Inputs are variables
— Excel related to this challenge can be downloaded from Challenge – Sum a Range Conditionally — Suppose, you have values in column A and D1 and D2 contains the range references. D3 contains the condition value for greater than. In this example, you will need to sum up between A4 and A8 where values…
Tips and Tricks 106 – Find the nth Largest Number when there are duplicates
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…