Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

One of the more interesting detailed conversations at DAC this year was with Teklatech, a small Danish company supplying a tool to improve dynamic IR drop and clock noise problems. Unlike analysis ...