Hi, please check out my Youtube video for the hack to replicate a formula down a column accurately and fast. 🙂
Tag: Excel
Using Excel pivot table cache to reduce the file size of Excel workbook
Excel workbook with pivot table is a common way to analyze data. But sometimes the workbook size will get too big especially when you have
Get Excel Data from another Excel workbook using Power Query, a better method compared to using Filter formula.
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
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
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 