Let’s play a song for 2021 Mother’s Day! Arietta By: Wolfgang Amadeus Mozart Performed By: Jocky Lai
Month: May 2021
How to Put Double Quotes (Quotation Marks) “” in Excel VBA?
I find the easiest way is to double up on the quotes to handle a quote. Some people like to use CHR(34)*: In this sample, the formula will check if D2 contains a space or not, Like ” ” and then decide which calculation to apply.
What is Cross-Report Drillthrough in Power BI and How to Use It?
With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection. To initiate cross-report drillthrough, you select Read More
How to Count Unique Values in Excel 365 – UNIQUE Function
The Excel UNIQUE function returns a list of unique values in a list or range. Values can be text, numbers, dates, times, etc. Extract unique values from range Return value Array of unique values Syntax =UNIQUE (array, [by_col], [exactly_once])Arguments array – Range or array from which to extract unique values. by_col – [optional] How to compare and extract. By Read More
How to Protect Power Queries in Excel?
Following are the STEPS ; We take advantage of Protection Structure in Excel. This is where the magic begins, follow carefully: 1. Stay in the Excel File and go to Review TabNote: (Excel and not Power Query) 2. Choose Protect Workbook 3. Ensure the Structure box is ticked 4. Provide a Password (optional) 5. Confirm by re-entering ( if password is Read More