How to Use Excel Database Functions for Advanced Data Key Functions That Power the Solution Several dynamic array functions are integral to building a robust formula for filling blank cells.