Getting data from another Excel workbook using Excel formula requires the source data workbook to be open in order to perform a data refresh, but
Tag: Excel
Using Excel formula to transpose every N rows in Excel
This video uses a simple and power Excel index formula to assist in transposing data with a N rows pattern. Please see the video and
Dynamic data filtering and creating sub-tables using FILTER function in Excel
Using a simple and powerful Excel FILTER function to create a dynamic data filtering, displaying sub-tables base on the dropdown selection and conditions.
Using Excel Countif formula and Data Validation to prevent duplicate entry into a column
Hi, Below is my Youtube video on using Excel countif formula and data validation to prevent duplicate data entry into a column. This method can
Using Excel and Power Query to get dynamic and refreshable web data (including cleaning and transforming)
Hi all, below is my YouTube video for using Excel and Power Query to fetch refreshable web data. This is useful for dashboarding and data
Pandas dataframe to Excel, retaining Excel sheet cells formatting
Hi, when we transfer a dataframe to an pre-formatted Excel sheet, there will be a common issue where the cell formatting of the Excel sheet
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 