Learn how to count non-blank cells in Excel using various formulas such as COUNTA, COUNT, SUBTOTAL, COUNTIF, SUMPRODUCT, and more.| Spreadsheet Planet
Learn how to filter data in Excel based on cell color using different methods such as the filter option, right-click menu, custom sort, and VBA script.| Spreadsheet Planet
Learn how to use the COUNTIF function in Excel for partial matching, including wildcard characters, with helpful examples and explanations.| Spreadsheet Planet
Learn how to count cells less than a specific value in Excel using COUNTIF, SUM, and IF functions, as well as the SUMPRODUCT function.| Spreadsheet Planet
Learn to paste data into filtered columns without affecting hidden cells in Excel (using a simple formula trick and some simple VBA code)| Spreadsheet Planet
Learn how to delete filtered rows in Excel using filters and VBA. Also, find out how to delete hidden rows without VBA.| Spreadsheet Planet