Archive for the ‘Excel table’ Category
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.
You can highlight duplicates in an excel defined table using conditional formatting. However, that won´t work if you only want […]
Marc asks: How to find Min and Max numeric values in a range of cells that have duplicate numbers and […]
David Hager gave this valuable comment about how to reference a table name in conditional formatting formulas: =INDIRECT("Table1[Start]") You can also use […]