Need a data validation formula for following assuming you are putting data validation in cell A2. The user should be able to enter a date in following format MM/YYYY for the year 2018 QQ/YYYY for the years 2019 to 2021 The solution to above challenge will be published after a month i.e. on 16-Jan-18.
Excel Quiz 42
Downloads 19 – Excel based Minutes of Meeting Template
Download link – MOM_Individual This is a Minutes of Meeting (MOM) template which can be used for individual meetings. Most of the MOM templates are based on Word format whereas this is based on Excel template.
Tips & Tricks 169 – Get the Source of a Pivot Table
1. Make a backup of your workbook. 2. Open your workbook and ALT+F11 3. Locate your Workbook name in Project Explorer Window 4. Right click on your workbook name > Insert > Module 5. Copy & Paste the below code in this module Now, you can call this function like =GetPivotRange(E5) Where E5 is any…
Excel Quiz 41
Solution – Challenge 69- Need Help in Not Showing Comments
Below is a possible solution to Challenge 69 – Need Help in Not Showing Comments These are not comments but Data Validation Messages.. Select the cell where pop up message is appearing > Data tab > Data Validation > The pop message is in the Input Message > Either you can remove messages or just…
Excel Quiz 40
Challenge 69 – Need Help in Not Showing Comments
Download the workbook. Whenever I select a cell, the yellow box pops up. I need your help to provide me instructions to remove these. The workbook can be downloaded from Challenge 69 – Comments The solution to above challenge will be published after a month i.e. on 20-Feb-2018.
Solution – Challenge 68 – Generate a Particular Sequence
Below is a possible solution to the problem Challenge 67 – Generate a Particular Sequence – This consists of 2 logic. Generate Triangular number. The formula for which is n*(n+1)/2 Generate Column Labels (A, B, AA, ZZ….) from numbers, the formula for which is =SUBSTITUTE(ADDRESS(1,3,4),1,"") where 3 is for column C. So, we need to…
Challenge 68 – Generate a Particular Sequence
Study the sequence below and you need to write a formula which when dragged down should generate the below sequence. For visual representation purpose, the sequence is in 5 columns but you need to generate the sequence in one column only. You need to generate upto 100 entries. The solution to this challenge will be…