Web select the data table range, including your formula, variable values cells, and empty cells for the results (d2:e8). Count blank cells using the find feature. Go to the data tab > data tools group, click the. Select and copy (ctrl+c) a table from the spreadsheet (e.g. Web fields return blank values in the attribute table and identify a dialog box after joining tables.