'Excel table' category
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.
The image above demonstrates a macro linked to a button. Press with left mouse button on the button and the […]
This article demonstrates how to insert and use a scroll bar (Form Control) in Excel. It allows the user to […]
The image above demonstrates a conditional formatting formula applied to an Excel Table containing random data. The Excel Table has […]
I will in this article demonstrate three different techniques to sort a data set in Excel. The first method sorts […]
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
This article demonstrates how to populate a drop down list with filtered values from an Excel defined Table. The animated […]
This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
This blog post demonstrates how to filter unique distinct values from an Excel table dynamically. When you change or add […]
This article demonstrates how to filter records occurring in only one out of two Excel defined tables. It also shows […]
Table of Contents How to compare two data sets - Excel Table and autofilter Filter shared records from two tables […]