Hey,

I was looking at that website earlier yesterday, but I can't get the named range to work in the pivot table so that it can be picked up properly by the list.

In applying the OFFSET formula for a dynamic named range to the pivot table I get "Amy, <blank>, <blank>, <blank>, Jake, <blank>, <blank>, <blank>" as my list options due to all the empty cells not being included in the count of the number of entries. This is because there are eight cells with contents in column A in the pivot table, so that formula is only counting 8 spaces from the top of the data when it creates my list.

Is there perhaps a way to alter this formula to count blank spaces in the named range formula but not include the blank spaces in the list?