Suppose you are given a list {"x", "100","200", "x300", 500} and you need to sum only the numbers 100, 200 and 500 in it. Then you can use following code
Author: Vijay A. Verma
SQL Quiz 1
Power BI Quiz 3
Excel & Power Query Challenges Week 1
Here are 7 Excel & Power Query challenges posted on Linkedin during Week 1. You can create your own solution and also can refer to solutions posted by others to learn from others. EXCEL CHALLENGE 1 2. EXCEL CHALLENGE 2 3. EXCEL CHALLENGE 3 4. POWER QUERY CHALLENGE 1 5. EXCEL CHALLENGE 4 6. EXCEL…
Tips & Tricks 187 – Give Smilie Faces to Ratings in Dashboards / Reports
This video will help you to create Smilie Faces for values given in your reports / dashboards. They will be Green for Happy Face, Yellow for Neutral Face and Red for Unhappy Face. Excel file used in this video – https://1drv.ms/x/s!Akd5y6ruJhvhvS7bd4uLFLchcsHE?e=jBxt0d
Tips & Tricks 186 – Multi Column VLOOKUP XLOOKUP
Power BI Quiz 2
DOWNLOADS 28 – Important Shortcuts in Excel – Pinup Reference
Very useful for starters in Excel. This updated document lists down important shortcuts in Excel in one page. You can also take a print of this and paste on your desk for ready reference. This is a copyright free document, hence you can use it the way you want – both personally as well as…
DOWNLOADS 27 – CTRL+SHIFT – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ SHIFT shortcut keys listed to keep you ahead of the competition. DOWNLOAD for printing – Excel – CTRL_SHIFT_Shortcuts Pinup Reference Shortcut Action Ctrl+Shift Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right Ctrl+Shift+A Insert argument…
Downloads 26 – Excel Formulas Bible V2
In 2017, I posted Excel Formulas Bible which was very much appreciated. Since then much water has flowed down the Excel river. Dynamic Array functions, XLOOKUP/XMATCH had been introduced. They have made life much simpler. Now, all formulas are treated as Array formulas, you need not enter them as Array formulas. So, 5 years down…