## Archive for Excel table

How to filter using OR logic between columns [Formula]

The filter feature in Excel won't allow you to do OR logic between columns, however, you can if you allow […]

Become more productive – Learn Excel Defined Tables

An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

Copy filtered Excel tables [VBA]

Today I want to share some pretty useful macros. My first macro copies an excel defined table with vba. It is […]

Scroll through a data set [VBA]

Sometimes you just want to show a small section of your data set, like in a dashboard or a chart. […]

This post describes how to add a map (background picture) to a chart. The following animated picture shows a scatter […]

Highlight duplicates in a filtered Excel defined table

You can highlight duplicates in an excel defined table using conditional formatting. However, that won´t work if you only want […]

Sort a table with an array formula

The sorted table to the right is created with an array formula using the data in the table to the left. Array […]

Find max unique value from a range that have duplicate numbers and blanks

Marc asks: How to find Min and Max numeric values in a range of cells that have duplicate numbers and […]

Today I am going to demonstrate how amazing pivot tables are! Take a look at this time sheet. You can expand […]

Cyril asks how to hide all columns of a range except columns whose header is found in specific cells. I am […]

How to use a Table name in Data Validation Lists and Conditional Formatting formulas

David Hager gave this valuable comment about how to reference a table name in conditional formatting formulas: =INDIRECT("Table1[Start]") Watch this video to […]

Copy excel table filter criteria [VBA]

Here is how to copy filter criteria from an excel table and use the same table filters on another table. […]