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.
Author: Vijay A. Verma
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…
Solution – Challenge 67 – Find Duplicates and Show the Count
Below is a possible solution to the problem Challenge 67 – Find Duplicates and Show the Count Use a helper column in which put following formula – =LEFT(SUBSTITUTE(IF(ISNUMBER(FIND("(",A2)),SUBSTITUTE(A2,"("," "),SUBSTITUTE(A2&"-","-","%")), " ","%",2),FIND("%",SUBSTITUTE(IF(ISNUMBER(FIND("(",A2)),SUBSTITUTE(A2,"("," "), SUBSTITUTE(A2&"-","-","%"))," ","%",2))-1) In the last column, put following formula – =IF(COUNTIF($B$1:B2,B2)=1,COUNTIF(B:B,B2),"") The solution work can be downloaded from Solution – Find Duplicates and…
Tips & Tricks 167 – Shortcut for Refresh All Pivot Tables Not Working
To refresh a Pivot table, the shortcut is ALT+F5. If you want to refresh all Pivots in the workbook, the shortcut is CTRL+ALT+F5. This magical shortcut would do the trick and you don't need any macro to perform this task. But on most of the computer this shortcut may not work. The reason is most…