Here is an example of a dynamic table without and with UDF's: In my example, there is the name of an existing excel table in B1 and a column header name in B2. The dynamic table (and formula) starts in A4. The formula for a dynamic table in A4. The table lists all unique values in an existing table Table's, Col and provides a count. There is a.