—- The worksheet for this challenge can be downloaded from Literacy Rates Graph —- Suppose, you have been given data for two categories as given below. The challenge before you is to make a chart like below. You can choose to post your answer in comments section. Note – Solution to this challenge will be published…
Tips & Tricks 96 – Abbreviate Given Names
If you have names given like – Smith Johnson Liz lotte Christy tiara Lewisk John And you need to produce abbreviations or acronyms for them like below in all capitals Smith Johnson – SJ Liz lotte – LT Christy tiara Lewisk – CTL john – J Then you can use following formula for the same…
Article 16 – Dependent Data List 02 – Creating Flexible / Dynamic Dependent Data List even First Drop Down is Flexible
— The Excel file related to this article can be downloaded from Dependent Drop Down List 02 — In Article 15, we saw that our Dependent Data list can grow / reduce vertically but we had fixed the horizontal range. Now, we will remove this restriction and our data list can grow / reduce vertically as…
Challenge 18 – Find the Longest Word in a List
— The worksheet related to this problem can be found at Longest Word — Suppose you have a list of words in A1 to A10. The challenge before you is to write a formula (preferably non-array) to find the longest word in the list. In case of ties, pick up the first longest word. The…
Excel Quiz 14
Article 15 – Dependent Data List 01 – Creating Flexible / Dynamic Dependent Data List
—- Excel file related to this article can be downloaded from Dependent Drop Down List —- In this article, I want to create a dynamic dependent data list. It means that entries can be added, removed at any point of time without impacting your Dependent Data List. Without making matter complicated, this article assumes that first…
Tips & Tricks 95 – Send Excel Workbook / Worksheet as Attachment
You can very easily send an Excel / Workbook as an attachment directly from Excel. To send Excel Workbook To use this functionality, your workbook need not be saved. When you use a step from below, it will attach that point of time copy of Excel workbook in the mail. File > Share > E…
Tips & Tricks 94 – Select Big Range Very Easily
You have a need to select A1 to A10. This is a very easy job to do. Suppose, you need to select A1 to A10000. Now, it becomes more cumbersome. Suppose you need to select E23 to AB4325. It is all the more cumbersome job for you. Approach 1 – Put the range in Name…
Challenge 17 – Sum if Y Appears More than One Time Consecutively Maximum
The Excel file related to this problem can be downloaded from Challenge – Most Consecutive Appearance Suppose you have a table like below. The challenge before you is to find the sum of prize money if Y appears consecutively more than once for a person maximum time. You need to input name in F2 and…