Empty cells percentage by vlookup

Hai
-I have two excel sheets.
-sheet1 contains 6 rows and sheet2 50 rows.

  • sheet 1 contain some empty cells in each row
    -so ihave to find the percentage of empty cells.
    -in sheet1 and sheet 2 there are “employee name” rows. sheet2 contains “location” row by that we have to find sheet1 employee belongs to which location and write in the sheet3 percentage of empty cells for each location

Please use COUNTBLANK formula to get the empty cells count.

Apply the formula to one of the cells using Write Formula activity and then use read cell activity to get the count.

Formula:
=COUNTBLANK("A2:G2")

Regards,
Karthik Byggari